SUMPRODUCT vs SUMIFS: weighted and conditional sums in Excel and Sheets

Excel & Google Sheets

=SUMPRODUCT(A2:A5,B2:B5)

✓

Verified example

Computed by a real spreadsheet engine on the sample data below.

=SUMPRODUCT(A2:A5,B2:B5)→130

Edit the grid or formula, then run it through a real spreadsheet engine — no signup.

Sample data — click any cell to edit

Formula

Runs server-side · free · no signup

1SUMPRODUCT multiplies quantity by price row-by-row, then adds the results: 2×10 + 3×20 + 1×30 + 4×5 = 130.
2SUMIFS cannot multiply two columns — it only sums one column where criteria match.
3Reach for SUMIFS for conditional totals; reach for SUMPRODUCT for weighted totals or multi-condition math.

SUMPRODUCT can also do conditional counts/sums with boolean arrays, e.g. SUMPRODUCT((A2:A5>10)*B2:B5).
SUMIFS is faster and clearer for straightforward criteria sums — don't over-use SUMPRODUCT.

Need it for your exact data?

Describe your columns in plain English and get the precise formula for your sheet, with the right Excel or Sheets syntax.

When you need to multiply arrays (quantity × price), or apply OR-logic across criteria that SUMIFS' AND-only model can't express.

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: May 28, 2026