Formualizer Docs
ReferenceFunctionsMath Functions

COUNTIF

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

Summary

COUNTIF evaluates each candidate cell against one criteria expression.

Remarks

  • Criteria support numeric comparisons and wildcard text matching.
  • Matching is case-insensitive for text criteria.
  • Non-matching or blank cells are not counted.

Examples

Count numbers greater than 10
Grid
CellValue
Formula
=
Result
Not evaluated yet.
Expected
2
Count text with wildcard
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
2
Exact-match criterion
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
2

FAQ

Is COUNTIF text matching case-sensitive?

No. Text criteria matching is case-insensitive.

Can COUNTIF evaluate wildcard criteria?

Yes. Criteria expressions support wildcard patterns for text.

Runtime metadata

Category

Math

Signature

COUNTIF(arg1, arg2, ... argN: Any)

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

Arity

min 2, max 1

Arguments

arg1

Any · Scalar

Caps

PUREREDUCTIONWINDOWEDSTREAM_OKPARALLEL_ARGSPARALLEL_CHUNKS

Source

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

COUNTBLANK

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

COUNTIFS

COUNTIFS: Counts cells that satisfy all supplied criteria pairs.

On this page

SummaryRemarksExamplesRelated functionsFAQIs COUNTIF text matching case-sensitive?Can COUNTIF evaluate wildcard criteria?Runtime metadata