Count cells that contain numbers between 2 numbers
You can count how many cells contain values in a particular range using the COUNTIFS function.
This function can return the number of cells between two values.
Example
The first criteria is any value greater than or equal to the smallest number.
The second criteria is any value less than or equal to the largest number.
|
Built-in Functions
COUNTIFS - The number of numerical values in a range that satisfies multiple conditions.
User Defined Function
COUNTBETWEEN - Returns the number of cells that have a value that is between a range.
Related Formulas
Count cells that contain dates between 2 dates
Count cells that contain numbers in a range
© 2023 Better Solutions Limited. All Rights Reserved. © 2023 Better Solutions Limited Top