COUNTA
| 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) | |
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.