counting numbers within a range

[Iain]

Trying to count numbers within ranges in a population. i.e total number
between 0 and 10, 11 & 20. Trying countif but doesn't seen to like multiple
criteria. only does greater than 0.
Any clues? I'm sure there is a way.
Thanks.

 

[Mike H]

Try


For 0 to 10
=SUMPRODUCT((A1:A15>=0)*(A1:A15<>"")*(A1:A15<=10))


For 11 to 20
=SUMPRODUCT((A1:A15>10)*(A1:A15<=20))

Mike

 

[muddan madhu]

may be ?

=COUNT(IF((A1:A5<>"")*(A1:A5<=10),)) ( use ctrl + shift + enter )

=COUNT(IF((A1:A5>10)*(A1:A5<=20),)) ( use ctrl + shift + enter )