Counting Anything With COUNTA
Tally every non-empty cell including text using COUNTA.
Beyond Just Numbers
The COUNT function only counts numbers. But real spreadsheets are full of text too: names, statuses, categories, and labels.
When you want to know how many cells have anything at all in them, you need COUNTA.
The extra A stands for "all" types of values. In this lesson you'll learn exactly what COUNTA tallies and when to reach for it.
Meet the COUNTA Function
COUNTA counts every cell that is not empty, no matter what kind of value it holds.
Its shape mirrors COUNT:
- =COUNTA(range)
Numbers, text, dates, TRUE/FALSE, and even error values all get counted. Only truly blank cells are skipped.
=COUNTA(A1:A10)All lessons in this course
- Counting Numbers With COUNT
- Counting Anything With COUNTA
- Finding Empty Cells With COUNTBLANK
- Spotting MAX and MIN Values