function contif

[Isaías.]

I´ve a list of numbers and want to use the count how many of this is within
the ranges

 

[Mike]

Checks the range A2 - A10 for numbers >=5 and <=20.
=COUNTIF(A2:A10,">=5")-COUNTIF(A2:A10,">20")

Mike

 

[Martin Fishlock]

Hi:

Another way to do it is sumproduct:

=sumproduct(--(A2:A10>=5),--(A2:A10<20))