COUNTA function in excel | Advance Excel Formula

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.


=COUNTA (value1, [value2], …)

value1 – Cell reference, or range
value2 – Cell reference, or range.