COUNTA Function In Excel

COUNTA Function In Excel

The COUNTA function is an inbuild statistical excel function. 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)