software

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, lt;=70 and lt;=75).

Thanks for your help.--
guile
------------------------------------------------------------------------
guile's Profile: www.excelforum.com/member.php...oamp;userid=21853
View this thread: www.excelforum.com/showthread...hreadid=505196Hi!

Try this:

=COUNTIF(A1:A20,quot;gt;=70quot;)-COUNTIF(A1:A20,quot;gt;75quot;)

Biff

quot;guilequot; gt; wrote in
message ...
gt;
gt; Suppose that I have a range of cells lets say A1 to A20. Then I put
gt; numbers ranging from 70 to 100.
gt;
gt; Then I will count the numbers 70-75 that appeared on my list. How would
gt; I type the formula.
gt;
gt; My idea is countif( A1-A20, lt;=70 and lt;=75).
gt;
gt; Thanks for your help.
gt;
gt;
gt; --
gt; guile
gt; ------------------------------------------------------------------------
gt; guile's Profile:
gt; www.excelforum.com/member.php...oamp;userid=21853
gt; View this thread: www.excelforum.com/showthread...hreadid=505196
gt;