Suppose that I have a range of cells lets say A1 to A20. Then I put
numbers ranging from 70 to 100.

Then I will count the numbers 70-75 that appeared on my list. How would
I type the formula.

My idea is countif( A1-A20, <=70 and <=75).

Thanks for your help.


--
guile
------------------------------------------------------------------------
guile's Profile: http://www.excelforum.com/member.php...o&userid=21853
View this thread: http://www.excelforum.com/showthread...hreadid=505196