Hi philamena,

Check out the COUNTIF function. :)

HTH

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


"philamena" wrote
in message ...

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