ExcelBanter - counting numbers within a range

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - counting numbers within a range (https://www.excelbanter.com/excel-discussion-misc-queries/207472-counting-numbers-within-range.html)

Iain

counting numbers within a range

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

counting numbers within a range

Try

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

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

Mike

"Iain" wrote:

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.

muddan madhu

counting numbers within a range

may be ?

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

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

On Oct 23, 3:12*pm, Iain wrote:
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.

All times are GMT +1. The time now is 02:29 PM.