COUNT
Formula Explanation
Returns the count of all values before the current row in the counting sequence.
- The total result displayed is the cumulative count up to the current row, not the total count of all data in the counting column.
- If the argument is a number, a date, or a text representing a number (e.g., a number enclosed in quotation marks like "1"), it will be included in the count.
- Boolean values and text directly entered as a number in the argument list are also included in the count.
Formula Syntax
In the result column, enter: count(column index)
Usage Example
Count the values in column CB2 and write the result in column CB3.
CB3 = count(CB2)
Empty cells in column CB2 are not counted.