Formualizer Docs
ReferenceFunctionsMath Functions

SUM

SUM: Adds numeric values across scalars and ranges.

Summary

SUM evaluates all arguments, coercing text to numbers where possible, and returns the total. Blank cells and logical values in ranges are ignored.

Remarks

  • If any argument evaluates to an error, SUM propagates the first error it encounters.
  • Unparseable text literals (e.g., "foo") will result in a #VALUE! error.

Examples

Basic scalar addition
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
35
Summing a range
Grid
CellValue
Formula
=
Result
Not evaluated yet.
Expected
30

FAQ

Why does SUM return #VALUE! for some text arguments?

Direct scalar text that cannot be parsed as a number raises #VALUE! during coercion.

Do text and logical values inside ranges get added?

No. In ranged inputs, only numeric cells contribute to the total.

Runtime metadata

Category

Math

Signature

SUM(arg1…: Number (Range))

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

Arity

min 0, max variadic

Arguments

arg1

Number · Range · coercion NumberLenientText

Caps

PUREREDUCTIONNUMERIC_ONLYSTREAM_OKPARALLEL_ARGS

Source

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

SQRTPI

SQRTPI: Returns the square root of a number multiplied by pi.

SUMIF

SUMIF: Adds values that satisfy a single criterion.

On this page

SummaryRemarksExamplesRelated functionsFAQWhy does SUM return #VALUE! for some text arguments?Do text and logical values inside ranges get added?Runtime metadata