Formualizer Docs
ReferenceFunctionsMath Functions

SUMSQ

SUMSQ: Returns the sum of squares of supplied numbers.

Summary

Returns the sum of squares of supplied numbers.

Remarks

  • Accepts one or more scalar values, arrays, or ranges.
  • For ranges, non-numeric cells are ignored while errors are propagated.
  • Date/time-like values in ranges are converted to numeric serial values before squaring.

Examples

Sum squares of scalar arguments
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
25
Ignore text cells in a range
Grid
CellValue
Formula
=
Result
Not evaluated yet.
Expected
5

FAQ

How does SUMSQ treat text cells in ranges?

Non-numeric range cells are ignored, while explicit errors are propagated.

Runtime metadata

Category

Math

Signature

SUMSQ(arg1…: Number (Range))

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

Arity

min 1, max variadic

Arguments

arg1

Number · Range · coercion NumberLenientText

Caps

PUREREDUCTIONNUMERIC_ONLY

Source

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

SUMPRODUCT

SUMPRODUCT: Multiplies aligned values across arrays and returns the sum of those products.

TAN

Returns the tangent of an angle in radians.

On this page

SummaryRemarksExamplesRelated functionsFAQHow does SUMSQ treat text cells in ranges?Runtime metadata