Help creating formula

Hello!
I am trying to create a formula to count a range of cells only if another range of cells is greater than or less than a certain number.
ex.
count a1:a30 if the corresponding T cell is greater than 1 and less than 10
(oh I forgot to mention that this will be pulling from another workbook)

Thanks in advance for all your help.

Hi philamena,

Check out the COUNTIF function.

HTH

--
Regards,
Zack Barresse, aka firefytr
To email, remove NOSPAM


"philamena" <[email protected]> wrote
in message news:[email protected]...
>
> Hello!
> I am trying to create a formula to count a range of cells only if
> another range of cells is greater than or less than a certain number.
> ex.
> count a1:a30 if the corresponding T cell is greater than 1 and less
> than 10
> (oh I forgot to mention that this will be pulling from another
> workbook)
>
> Thanks in advance for all your help.
>
>
> --
> philamena
> ------------------------------------------------------------------------
> philamena's Profile:
> http://www.excelforum.com/member.php...o&userid=33011
> View this thread: http://www.excelforum.com/showthread...hreadid=528348
>