CountIF Question

[guile]

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.

 

[Biff]

Hi!

Try this:

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

Biff