function contif
Hi:
Another way to do it is sumproduct:
=sumproduct(--(A2:A10=5),--(A2:A10<20))
--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.
"Mike" wrote:
Checks the range A2 - A10 for numbers =5 and <=20.
=COUNTIF(A2:A10,"=5")-COUNTIF(A2:A10,"20")
Mike
"IsaÃ*as." wrote:
I´ve a list of numbers and want to use the count how many of this is within
the ranges
|