SUMPRODUCT Function in Google Sheets

Multiply corresponding components in given arrays and return the sum using the SUMPRODUCT function.

SUMPRODUCT Function

The SUMPRODUCT function in Google Sheets multiplies corresponding components in given arrays and returns the sum of those products.

Syntax

SUMPRODUCT(array1, [array2, ...])
  • array1: The first array or range.
  • array2, ...: Additional arrays or ranges to include (optional).

Examples

  1. Basic Example

Multiply corresponding elements of arrays A1:A3 and B1:B3 and sum the results:

=SUMPRODUCT(A1:A3, B1:B3)

Notes

  • Useful for weighted averages and other calculations involving multiple arrays.
  • MMULT: Multiply matrices.