Show contents 

Creating Pixel-Perfect Reports > Getting Started with the Reports Tool in the Desktop Application > Building Report > Adding a New Sheet and Working with It > Working with Report Sheet Data > Using Formulas > Function Wizard > Mathematical Functions > Count

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