Advanced Math

SUMPRODUCT

Multiplies corresponding elements across one or more ranges, then adds up the results.

Compatibility: All Excel versions

Syntax

Example

When to Use It

Use SUMPRODUCT to calculate something like total revenue from separate Quantity and Price columns in one formula, without needing a helper column — or to build conditional sums/counts using array logic beyond what SUMIFS can do.