Microsoft Office Tutorials and References

In Depth Information

**Basic Counting Formulas**

Counting nonblank cells

The following formula uses the COUNTA function to return the number of nonblank cells in a

range named
Data:

=COUNTA(Data)

The COUNTA function counts cells that contain values, text, or logical values (TRUE or FALSE).

If a cell contains a formula that returns an empty string, that cell is included in the

count returned by COUNTA even though the cell appears to be blank.

Counting numeric cells

To count only the numeric cells in a range, use the following formula, which assumes that the

range is named
Data:

=COUNT(Data)

Cells that contain a date or a time are considered to be numeric cells. Cells that contain a logical

value (TRUE or FALSE) are not considered to be numeric cells.

Counting nontext cells

The following array formula uses Excelâ€™s ISNONTEXT function, which returns TRUE if its argument

refers to any nontext cell (including a blank cell). This formula returns the count of the number of

cells not containing text (including blank cells):

{=SUM(IF(ISNONTEXT(Data),1))}

Counting text cells

To count the number of text cells in a range, you need to use an array formula. The array formula

that follows returns the number of text cells in a range named
Data:

{=SUM(IF(ISTEXT(Data),1))}