COUNTA function.Get non-blank counts.(Microsoft Excel)
The COUNTA function retrieves the number of non-blank cells in a specified cell range.
It is a companion to the COUNT function to obtain non-numeric counts.
Contents
How it works
=COUNTA(value1 to 255)
Name | Omission | Explanation |
---|---|---|
value1 to 255 | Required argument. Specify the range of cells from which to obtain the number of cases. |
Demonstrate
Not only numbers, but also Boolean values, error values, and strings. Blank cells are excluded.

Blank strings are treated as containing formulas, so they are not judged as blank cells and are counted.

---
Discussion
New Comments
No comments yet. Be the first one!