Formualizer Docs
ReferenceFunctionsMath Functions

SUMPRODUCT

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

Summary

SUMPRODUCT supports scalar or range inputs, applies broadcast semantics, and accumulates the product for each aligned cell position.

Remarks

  • Input shapes must be broadcast-compatible; otherwise SUMPRODUCT returns #VALUE!.
  • Non-numeric values are treated as 0 during multiplication.
  • Any explicit error value in the inputs propagates immediately.

Examples

Pairwise sum of products
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
32
Range-based sumproduct
Grid
CellValue
Formula
=
Result
Not evaluated yet.
Expected
200
Text entries contribute zero
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
4

FAQ

Why does SUMPRODUCT return #VALUE! with some array shapes?

The argument arrays must be broadcast-compatible; incompatible shapes raise #VALUE!.

How are text values handled in multiplication?

Non-numeric values are treated as 0, unless an explicit error is present.

Runtime metadata

Category

Math

Signature

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

PUREREDUCTION

Source

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

SUMIFS

SUMIFS: Adds values that satisfy multiple criteria.

SUMSQ

SUMSQ: Returns the sum of squares of supplied numbers.

On this page

SummaryRemarksExamplesRelated functionsFAQWhy does SUMPRODUCT return #VALUE! with some array shapes?How are text values handled in multiplication?Runtime metadata