The Excel Count and Counta functions both count the number of values within a supplied set of values or range of cells.
The two functions differ in the following ways:
The Excel Counta function returns the number of non-blanks within a supplied set of cells or values.
The syntax of the function is:
Where the arguments, value1, [value2], etc., can be values, arrays of values, or references to cell ranges.
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.
Column C of the following spreadsheet shows examples of the Counta function, used to return the number of non-blank cells in one or more supplied cell ranges.
In the following spreadsheet, the Excel Counta function is used to return the number of non-blank values within a set of values that is supplied directly to the function.
Further examples of the Excel Counta function are provided on the Microsoft Office website.