SUMPRODUCT Function in Excel: Syntax, Examples and Free Practice

By Rinkesh Shah, founder of Cellgrids.

SUMPRODUCT is an Excel Math & Trig function. Multiplies matching items across ranges, then adds up the results.

SUMPRODUCT syntax

=SUMPRODUCT(array1, [array2], ...)

SUMPRODUCT is used in financial models and engineering-style calculations where precise numeric work is needed.

Open the live Excel-style spreadsheet and try SUMPRODUCT yourself. No Excel install or sign-up needed to start.

What does the SUMPRODUCT function do in Excel?

Multiplies matching items across ranges, then adds up the results.

What is the syntax of SUMPRODUCT in Excel?

The syntax is =SUMPRODUCT(array1, [array2], ...). array1: The first range or array; array2: The second range or array (optional).

Where can I practice SUMPRODUCT online for free?

Open the free live spreadsheet on Cellgrids and try SUMPRODUCT yourself. No Excel install is needed and you can start without signing up.