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
- 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