COUNTBETWEEN
COUNTBETWEEN(range, min_value, max_value)
Returns the number of cells that have a value that is between "min_value" and "max_value".
| range | The range of cells you want to count. |
| min_value | The smallest value (inclusive). |
| max_value | The largest value (inclusive). |
REMARKS
* The values can be numbers or dates.
* You can use the built-in COUNT function to
* You can use the add-in COUNTFORMAT function to
* You can use the add-in COUNTSUBSTRING function to
* Similar to the MAXBETWEEN, MINBETWEEN, SUMBETWEEN and ISBETWEEN user defined functions.
![]() |
MORE FUNCTIONS
??
© 2026 Better Solutions Limited. All Rights Reserved. © 2026 Better Solutions Limited TopPrevNext
