CountCells

 Counts the number of cells in a set of cells.

Syntax

CountCells(cellref1, cellRef2, ...)
NbCells(cellref1, cellRef2, ...)
cellref1 = first cell or range reference
cellref2 = second cell or range reference
... = nth cell or range reference

Remarks

This function accepts an unlimited number of parameters.

If you only want to count non-empty cells, see Count.

Examples

CountCells(A1, B3) = 2
CountCells(A1:B3) = 6

Classification

Ranges