[Solved] Counting number of values within a given range

[RGB3D]

I'm sure this must have been explained, but I haven't been able to locate the answer. I have a column of numbers (hundreds of entries in a single column) for which I'd like to count up how many fall within a numeric range (e.g. between 15 and 30). I've tried COUNTIF a number of ways, but I can't figure out how to do the criteria to establish the range within which the number must fall to be counted. I'd love a pointer to a solution. Thanks!

[RusselB]

Use the (currently undocumented) COUNTIFS function.
By getting to the first bracket for the function entered into a cell, you should see a balloon indicating how the rest of the parameters need to be entered.
It is similar, but not the same, as the COUNTIF function.
Alternatively, the SUMPRODUCT function can also work in this manner.

[Zizi64]

When the numbers are in the column A, then the COUNTIFS() mathematically equals to:

Code: Select all

=COUNT(A1:A400)-COUNTIF(A1:A400;"<15")-COUNTIF(A1:A400;">30")

or:

Code: Select all

=COUNTIF(A1:A400;">=15")-COUNTIF(A1:A400;">30")

Maybe you need use "<=" and/or ">=" relations.

[RGB3D]

I'll take a look at the COUNTIFS() function and see how to employ it. I appreciate that new tool. Thanks as well for the mathematically obvious formula (that I overlooked) from Zizi64. Excluding the numbers above the top value in the range is the same as counting just the numbers between. Excellent! The simplest answers are sometimes the best. Works great - thanks, guys!

[RGB3D]

Works great - thanks! (Now how do I mark this solved?)

[Zizi64]

Please edit your first post. Add the [Solved] string to the begining of the Title of this topic.