COUNTA Function in Excel

COUNTA Function in Excel returns the count of non-blanks cell. In other words, COUNTA Function count the cells only if the cells have some values in it.

Syntax of COUNTA Function in Excel:

COUNTA( value1, [value2], … )

Arguments, value1, [value2], etc. can be values or references to cell ranges.

 

Example of COUNTA Function in Excel

Formula

COUNTA Function in Excel 1

  • The numbers and the date 03/01/2017 , The text value “name”, the logical value FALSE, TRUE and the error value #N/A, #VAL! are counted by the COUNTA function.
  • The empty cells are not counted by the COUNTA function.

So the first six rows will be taken for the count and the result will be

Result

COUNTA Function in Excel 2

previous COUNTA Function in Excel                                                                                                                next COUNTA Function in Excel