COUNT

Counts the number of items in a list to help analyze dataset size or entries.

The COUNT function returns the number of items in a list by counting the values provided in the arguments. It accepts numeric values or cell 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 (Required).

Example

COUNT(filterif([Column1,Column2,Column3],">1000"))

Returns the count of values that are greater than 1000.

Excel equivalent

COUNT