SUMPRODUCT
Math & trigExcel 2007Multiply arrays element-by-element and sum the result — a Swiss-army knife.
Syntax
SUMPRODUCT(array1, [array2], …)
How it works
Also does conditional counting/summing in older Excel: multiply boolean arrays (a condition each) together.
Examples
=SUMPRODUCT(qty, price)
→ order total
=SUMPRODUCT((region="North")*(year=2026)*sales)
→ two-condition sum, any Excel version
=SUMPRODUCT((A2:A100<>"")/COUNTIF(A2:A100, A2:A100&""))
→ count of distinct values
Related functions
More Math & trig functions
Syntax follows Microsoft’s documentation. Examples are written to be pasted into a cell and checked. Argument separators may be ; in your locale. The AI explainer runs on a free community model — verify anything important.