Microsoft Excel Functions & Formulas

Use the COUNT function to count cells

containing numeric data

To count all cells that contain numbers, use the COUNT function.

Empty cells, logical values, text, and error values are ignored.

COUNT(value1, value2, ...)

value1, value2, ...: From 1 to 30 arguments of any type of data.

However, all but numeric data is ignored.

4

To count the number of cells that contain numbers:

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

2. Select cell C1 and type the following formula:

=COUNT(A1:A10).

3. Press <Enter>.

Note: Arguments that are date and time values are counted

as numeric too.

Basic Statistical Functions

135

5

Figure 5-10