COUNTA

Posted on 17-01-2020 , by: admin , in , 0 Comments

COUNTA

What Does It Do?
This function counts the number of numeric or text entries in a list.
It will ignore blanks.

Syntax
=COUNTA(Range1,Range2,Range3… through to Range30)

Formatting
No special formatting is needed.

Entries To Be Counted Count
10 20 30 3  =COUNTA(C4:E4)
10 0 30 3  =COUNTA(C5:E5)
10 -20 30 3  =COUNTA(C6:E6)
10 ####### 30 3  =COUNTA(C7:E7)
10 21:30 30 3  =COUNTA(C8:E8)
10 0.00739 30 3  =COUNTA(C9:E9)
10 30 2  =COUNTA(C10:E10)
10 Hello 30 3  =COUNTA(C11:E11)
10 #DIV/0! 30 3  =COUNTA(C12:E12)

Leave a comment