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 blank or empty cells in a range

To count blank or empty cells within a given range you use the COUNTBLANK function.

  • Cells with formulas that return “” (empty text) are counted.
  • Cells with zero values are not counted.
  • Cells with spaces are not counted.

Syntax

COUNT(range)

Examples:

COUNTBLANK(A1:A20)

In the example below, cell B12 contains the function: =COUNTBLANK(B1:B11). The result is 5. This is a result of counting cells B2, B5, B6, B8 (contains a formula that returns an empty text) and B10.

Cell B11 is not counted because it contains spaces.