The Excel Counta function returns a count of non-blanks within a supplied set of cells or values. The function is commonly used to return the number of non-blank cells in a range. However, as well as ranges of cells, the Counta function can directly received arrays of values, which are not stored in cells.
Syntax: COUNTA( value1, [value2], … )
Where the arguments, value1, [value2], etc, can be any values or references to cell ranges.
In Excel 2007 or 2010, you can enter up to 255 value arguments to the Excel Counta function, each of which may consist of any number of cells or values. However, in Excel 2003 and earlier, the function can only handle up to 30 arguments. Note that, if a cell contains an empty text string or a formula that returns an empty text string, this cell is counted as a non-blank by the Counta function.
Counta Function Examples
Example 1 – Values Supplied from a Range of Worksheet Cells
The following spreadsheet shows two examples of the Excel Counta function used to count non-blank cells in one or more supplied cell ranges.
Example 2 – Values Supplied Directly to the Excel Counta Function
The following spreadsheet shows an example of the Excel Counta function, with the values supplied directly to the function.
Example 3 – Values Supplied Directly to the Excel Counta Function
The following spreadsheet shows an example of the Excel Counta function
Excel COUNT & COUNTA Functions
As the Excel Count and the Excel Counta functions are often confused, the differences are outlined below:
|–||The COUNT function returns the count of numeric values (i.e. numbers or dates) within a supplied set of cells or values.|
|–||The COUNTA function returns the count of non-blanks within a supplied set of cells or values.|