by COUNTA function counts cells containing any type of information, including error values and empty text (“”). The COUNTA function does not count empty cells.
Syntax
COUNTA(value1, value2,….)
As shown bellow in this example taken a scenario of seminar seat booking system in excel using COUNTA function.
Function : =COUNTA(A3:S15)
