COUNTA Posted on 17-01-2020 , by: admin , in Uncategorized , 0 Comments previous NEXT 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)FormattingNo 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) previous NEXT