counting numbers within a range

  • Thread starter Thread starter Iain
  • Start date Start date
I

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.
 
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
 
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 )
 
Back
Top