To work with the tool in Foresight Analytics Platform 10, use the new interface.

Count

The function wizard for the Count function looks as follows:

Syntax

Count(Values1, …)

Parameters

Values1, Values2, …, ValuesN. The cell range, for which you want to find the average.

NOTE. Both value itself or address of the cell (cell range) containing this value can be specified as the parameter.

Description

It returns the number of elements in an array of cells.

Example

Formula Result Description
= Count(A1:A3, A5:A6, B7) 6 Number of elements in the cells A1:A3, A5:A6 and B7.
= Count(10, 82, 13, 4, 51) 5 Number of elements in the array of specified values.

See also:

Function Wizard │ Mathematical Functions │ Average