Summary of Excel count functions

COUNT

Counts the number of cells that contain numbers within a given range. It can also accept a list of  arguments other than cell ranges and counts numbers within that list of arguments. Use COUNT to find out how many cells or arguments that have numeric values.

Syntax

COUNT(value1,value2,…)

Read more …


COUNTA

Counts the number of cells that are not empty and the values within the list of arguments. Use COUNTA to count the number of cells that contain data in a range or array.

Syntax

COUNTA(value1,value2,…)

Read more …


COUNTBLANK

Counts empty cells in a specified range of cells.

Syntax

COUNTBLANK(range)

Read more …


COUNTIF

Counts the number of cells within a range that meet the given criteria.

The criteria can be a number, text, expression or a cell reference.

Syntax

COUNTIF(range,criteria)

Read more …

Applies to Excel 2003


How to count cells that contain data

To count cells, within a given range or list of arguments, that contains data, you use the COUNTA function.

Data in this context includes error values, spaces and empty text (“”).

Syntax

COUNTA(value1,value2,…)

Examples:

COUNTA(A1:A20) :counts any nonblank cells in a range of cells.
COUNTA(A1:A20, 7,”ABC”) :counts nonblank in a range of cells plus the second argument (7), and the third argument “ABC”.

In the example below, cell B7 contains the function: =COUNTA(B1:B9). The result is 6. Here the non blank cells are B1, B3, B4, B6, B7 (formula that returns an empty text) and B9 (contains spaces).

Applies to: Excel 2003