COUNTA function.Get non-blank counts.(Microsoft Excel)

01/21/2023

Japanese version.

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.

How it works

=COUNTA(value1 to 255)
NameOmissionExplanation
value1 to 255Required 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.

---

Links

Microsoft Excel Functions Statistical

Examples of Use

Formula to randomly extract a specified number of cells from a range of cells.

Formula to extract only rows with values.

How to remove duplicates and count them.