Formualizer Docs
ReferenceFunctionsMath Functions

COUNTIFS

COUNTIFS: Counts cells that satisfy all supplied criteria pairs.

Summary

COUNTIFS applies each (criteria_range, criteria) pair and counts rows where all tests pass.

Remarks

  • Requires one or more criteria pairs.
  • Criteria support operators and wildcard matching.
  • A row contributes to the result only when every criterion evaluates true.

Examples

Count rows matching two filters
Grid
CellValue
Formula
=
Result
Not evaluated yet.
Expected
1
Wildcard text matching
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
2
No rows meeting all criteria
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
0

FAQ

Why can COUNTIFS return 0 even when one criterion matches rows?

Each row must satisfy every criterion pair; partial matches are excluded.

Does COUNTIFS require at least one criteria pair?

Yes. It expects arguments in (range, criteria) pairs.

Runtime metadata

Category

Math

Signature

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

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

Arity

min 2, max variadic

Arguments

arg1

Any · Scalar

Caps

PUREREDUCTIONWINDOWEDSTREAM_OKPARALLEL_ARGSPARALLEL_CHUNKS

Source

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

COUNTIF

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

CSC

CSC: Returns the cosecant of an angle, defined as `1 / SIN(angle)`.

On this page

SummaryRemarksExamplesRelated functionsFAQWhy can COUNTIFS return 0 even when one criterion matches rows?Does COUNTIFS require at least one criteria pair?Runtime metadata