Building Report for Printing > Building Report > Using Table Sheet > Adding a New Sheet and Working with It > Working with Table Sheet Data > Using Formulas > Function Wizard > Mathematical Functions > Count
The function wizard for the Count function looks as follows:
Count(Values1, …)
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.
It returns the number of elements in an array of cells.
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: