Hi!

Try this:

=COUNTIF(A1:A20,"=70")-COUNTIF(A1:A20,"75")

Biff

"guile" wrote in
message ...

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