COUNTA function.... is also used in Excel for counting. The COUNTA function counts all the cells except the blank cells in a data range in which text, symbols or any kind of data is stored.
Syntax
=COUNTA (value1, [value2], …)
value1 – Cell reference, or range
value2 – Cell reference, or range.
