Formualizer Docs
ReferenceFunctionsMath Functions

COUNTBLANK

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

Summary

COUNTBLANK treats both true empty cells and "" text values as blank.

Remarks

  • Empty-string text values are counted.
  • Numbers, booleans, and non-empty text are not counted.
  • Supports scalar arguments and ranges.

Examples

Count blanks in a range
Grid
CellValue
Formula
=
Result
Not evaluated yet.
Expected
2
Scalar empty-string counts as blank
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
1
Non-empty values are excluded
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
0

FAQ

Does COUNTBLANK include cells that contain ""?

Yes. Empty-string text values are treated as blank for COUNTBLANK.

Are numeric zeros considered blank?

No. Zero is a numeric value, so it is not counted as blank.

Runtime metadata

Category

Math

Signature

COUNTBLANK(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

COUNTA

COUNTA: Counts non-empty cells and scalar arguments.

COUNTIF

COUNTIF: Counts cells in a range that satisfy a single criterion.

On this page

SummaryRemarksExamplesRelated functionsFAQDoes COUNTBLANK include cells that contain ""?Are numeric zeros considered blank?Runtime metadata