ReferenceFunctionsMath Functions

COUNTA

COUNTA: Counts non-empty cells and scalar arguments.

Summary

COUNTA counts any value except true empty cells.

Remarks

Numbers, text, booleans, and errors all count.
Empty string values ("") are counted as non-empty.
Truly empty cells are the only values excluded.

Examples

Count mixed populated values

Grid

Cell	Value
No inputs on Sheet1.

Formula

=

Result

Not evaluated yet.

Expected

4

Range count excludes only true blanks

Grid

Cell	Value

Formula

=

Result

Not evaluated yet.

Expected

2

Errors are counted

Grid

Cell	Value
No inputs on Sheet1.

Formula

=

Result

Not evaluated yet.

Expected

2

FAQ

Does COUNTA count empty-string results like ""?

Yes. Empty text is counted as non-empty by COUNTA.

Are error values counted?

Yes. Errors are considered populated values and increase the count.

Runtime metadata

Category

Math

Signature

COUNTA(arg1…: Any)

This function accepts a repeating argument pattern (min args: 1).

Arity

min 1, max variadic

Arguments

arg1

Any · Scalar

Caps

PUREREDUCTION

Source

crates/formualizer-eval/src/builtins/math/criteria_aggregates.rs

COUNT

Counts numeric values across scalars and ranges.

COUNTBLANK

COUNTBLANK: Counts blank cells, including empty-string text results.

On this page

Summary Remarks Examples Related functions FAQ Does COUNTA count empty-string results like ""?Are error values counted?Runtime metadata