Microsoft Excel Functions & Formulas

Use the COUNTA function to count cells

containing data

To count all cells that are not empty and contain data in a range or

array, use the COUNTA function.

COUNTA(value1, value2, ...)

value1, value2, ...: 1 to 30 arguments representing the values to

be counted.

4

To count all cells containing data:

1. In cells A1:A10 type any kind of data (numeric and text).

2. Select cell C1 and type the following formula:

=COUNTA(A1:A10).

3. Press <Enter>.

Note: The COUNTA function does not count empty cells.

136 Chapter 5

Figure 5-11