Formualizer Docs
ReferenceFunctionsMath Functions

SUMIF

SUMIF: Adds values that satisfy a single criterion.

Summary

SUMIF evaluates each cell in range against criteria, then sums corresponding values.

Remarks

  • If sum_range is omitted, matching cells from range are summed.
  • Criteria support operators like ">10" and wildcard text patterns.
  • Cells that do not coerce to numbers in the sum target contribute 0.

Examples

Sum values above a threshold
Grid
CellValue
Formula
=
Result
Not evaluated yet.
Expected
40
Use separate sum range
Grid
CellValue
Formula
=
Result
Not evaluated yet.
Expected
30
Wildcard criteria
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
7

FAQ

What happens when matching cells are non-numeric in SUMIF?

They contribute 0 to the sum target after coercion logic.

Can SUMIF use wildcard criteria like * and ??

Yes. Text criteria support wildcard matching semantics.

Runtime metadata

Category

Math

Signature

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

SUM

SUM: Adds numeric values across scalars and ranges.

SUMIFS

SUMIFS: Adds values that satisfy multiple criteria.

On this page

SummaryRemarksExamplesRelated functionsFAQWhat happens when matching cells are non-numeric in SUMIF?Can SUMIF use wildcard criteria like * and ??Runtime metadata