| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| counting numbers in a range | Excel Worksheet Functions | |||
| two columns range of numbers need to list all numbers in the range | New Users to Excel | |||
| Counting from one range to another range, multiple criteria | Excel Discussion (Misc queries) | |||
| Counting Unique Part Numbers In A Range | Excel Worksheet Functions | |||
| Counting if numbers fall within a specified range | Excel Discussion (Misc queries) | |||
Linear Mode
