Example you have a table like that:
And you want to count how many students in the class have a score greater than 5 and less than 8.
In this case, I use formula:
The result is two because just Sue Bryce and Andy Samberg are satisfied conditions ( a score greater than 5 and less than 8).
To group numeric data into ranges, you can build a summary table and use COUNTIFS to count values at each threshold.
We have general formula:
- ‘range‘ represents a range of cells that contain numbers (Example: A2:A9)
- Low and high are term