Table of Contents
Count is used to count the number of cells in a range that contain numerical data, whereas COUNTA is used to count the number of cells in a range that are not empty. This means that COUNTA is used to count cells that contain data of any type, including text, numbers, and errors.
In Excel, the COUNT and COUNTA functions both count the number of cells in a range, but they use slightly different behaviors:
- The COUNT function counts the number of cells in a range that contain numbers.
- The COUNTA function counts the number of cells in a range that are not empty.
The COUNT function is useful for counting the number of cells in a range that contain numeric values.
The COUNTA function is useful for counting the number of cells in a range that contain any value.
The following examples show how to use each function in practice.
Example 1: All Values in Range are Numeric
If we use the COUNT and COUTNA functions to count the number of cells in a range in which every cell is numeric (or blank), the two functions will return the same value:
In this case, there are 9 cells in the Sales column that contain numeric values and one cell that is blank.
The COUNT function tells us that there are 9 cells with numeric values in the Sales column.
The COUNTA function tells us that there are 9 cells with any value in the Sales column.
Example 2: Some Values in Range are Not Numeric
If we use the COUNT and COUTNA functions to count the number of cells in a range in which some cells are not numeric, the two functions will return different values:
In this case, there are seven cells in the Sales column that contain numeric values, two cells that contain character values, and one cell that is blank.
The COUNT function tells us that there are 7 cells with numeric values in the Sales column.
The COUNTA function tells us that there are 9 cells with any value in the Sales column.