## How to use the COUNTA function

*Article updated on March 29, 2018*

The COUNTA function counts the non-empty or blank cells in a cell reference.

The picture above demonstrates the COUNTA function entered in cell F3. The evaluated range is C3:C10, two of the cells contains formulas, three cells seem to be empty but only one is in fact empty.

Cell C4 has a formula that returns a blank, note that the COUNTA function considers this cell not empty. Cell C7 has a space character and is therefore counted. Only cell C6 is empty.

### Excel Function Syntax

COUNTA(*value1*, [*value2*], ...)

### Arguments

value1 |
Required. A cell reference to a range for which you want to count not empty values. |

[value2] |
Optional. Up to 254 additional arguments like the one above. |

### Comments

The COUNTA function counts errors as not empty.

### Articles with the 'COUNTA' Function

The following 9 articles have formulas that contain the COUNTA function.

Create dependent drop down lists containing unique distinct values

This article explains how to build dependent drop down lists. Here is a list of order numbers and products. We […]How to create a dynamic pivot table and refresh automatically

David Hager commented: Looks like an easy pivot table solution to me. Thanks for your comment! Now i know how to […]Create a drop down list containing alphabetically sorted values

Overview This article describes how to create a drop down list populated with sorted values from A to Z. The […]### Functions in 'Statistical'

The COUNTA function function is one of many functions in the 'Statistical' category.