Returns the number of values which can be interpreted as numbers. COUNT (1, 2, BLANK (), "3", "test", TRUE, Color.Red) COUNT (1; 2; BLANK (); "3"; "test"; TRUE; Color,Red) returns 4, because only the 1, 2, "3" and TRUE parameters can be interpreted as numbers.

This function only counts numbers, temporal values, logical values and text values representing numbers (as parsed using TONUMBER). Temporal values are counted, as they can be interpreted as numbers. Blank values, in particular, are ignored. To count the number of elements in an array, use SIZE instead.

COUNT takes the configured locale into account when converting text strings to numbers. If the locale is German, for instance, text strings representing numbers should use a comma (",") as a decimal separator. If the locale is UK English, a decimal point (".") should be used. Thousands separators may not be used.

Count anything

Using a combination of FILTER and SIZE, you can use any criteria you like. Consider this formula:

The formula above returns a version of NumberArray where only elements greater than 4 are included. Use the SIZE function to count the number of elements in the returned array:

The formula above returns the number of elements of NumberArray which are greater than 4.

It's easy to replicate what COUNT does armed with this knowledge, and the fact that TYPE can be used to determine if an array element is a number, a temporal value or a logical value:

The formula above returns the number of array elements which are numbers, temporal values, logical values, or are text strings that can be successfully parsed using TONUMBER and are not blank, which is exactly what COUNT does. TONUMBER returns an error if a text string can't be turned into a number, which ISERROR checks for. The TYPE (Element) = 2 TYPE (Element) = 2 test restricts that check to text strings, as TONUMBER also succeeds when given a color. || is the "logical or" operator, which is equivalent to the OR function in non-array contexts. && is the "logical and" operator, equivalent to the AND function. ! is the "logical negation" operator which turns FALSE into TRUE and TRUE into FALSE.

Counting can also be done with REDUCE. Here's the equivalent REDUCE formula:

Refer to the REDUCE documentation to learn more about how this example works (specifically, this example is similar to the XOR example in that documentation).