COUNT

The COUNT function returns the number of values in a list by counting the values provided in the arguments. It accepts numeric values or node references and is commonly used to determine the size of a dataset or the number of entries in a range.

Syntax

COUNT(value1, value2, ...)

Arguments

• value1, value2, ...: A list of values or node references to count.

Return value

Returns the count of values in the list.

Example

COUNT(FILTERIF([2024 Actuals, 2025 Actuals, 2026 Actuals], ">0"))

In this example, the COUNT function returns the count of values greater than 0 in 2024 Actuals, 2025 Actuals, and 2026 Actuals.

Excel equivalent

COUNT