➕ Google Sheets summary examples

Sumproduct Examples in Google Sheets

Multiply arrays and add the results for weighted totals or conditional logic. This page gives a clear pattern, five practical examples and common mistakes to avoid.

Updated 2026-06-125 practical examplesCopy-ready formulas

💡 Ideas for You

Learning resources for Google Sheets formulas, trackers and reports.

4 useful links

📚Step-by-step books
Start with beginner-friendly step-by-step books and learning resources from Create & Learn.
🟩Sheets guide
Helpful references for formulas, QUERY, IMPORTRANGE and everyday Sheets tasks.
🧮Formula books
Resources for spreadsheet formulas, arrays, lookups and text cleanup.
📋Spreadsheet templates
Ideas for trackers, dashboards, checklists and planning spreadsheets.

Some links in this section may be affiliate links. Choose only what is useful for your own work.

Syntax or pattern

Multiply arrays and add the results for weighted totals or conditional logic.

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

✍️

5 practical examples

1

Summarize sales by region

Add sales where the region matches the selected row.

=SUMIFS(Sales!E:E, Sales!B:B, A2)

Adjust the ranges, criteria and sheet names to match your workbook.

2

Count open tasks

Count open tasks by owner or category.

=COUNTIFS(Tasks!D:D, "Open", Tasks!B:B, A2)

Adjust the ranges, criteria and sheet names to match your workbook.

3

Average response time

Average a metric for one team, status, or issue type.

=AVERAGEIFS(Tickets!F:F, Tickets!C:C, A2)

Adjust the ranges, criteria and sheet names to match your workbook.

4

Calculate a filtered total

Add values that match a category.

=SUMIF(Categories!A:A, A2, Categories!D:D)

Adjust the ranges, criteria and sheet names to match your workbook.

5

Create a monthly total

Summarize values for one calendar month.

=SUMIFS(Data!E:E, Data!A:A, ">="&G1, Data!A:A, "<="&EOMONTH(G1,0))

Adjust the ranges, criteria and sheet names to match your workbook.

Common mistakes to avoid

Using ranges with different lengths in multi-condition formulas.
Forgetting date criteria need operators joined with &.
Summarizing blanks or hidden helper rows unintentionally.

FAQ

What is this Google Sheets page for?

This page gives copy-ready examples for sumproduct examples so you can understand the pattern and adapt it to real spreadsheet work.

Can I copy these formulas directly?

Yes. Use the copy buttons, then adjust sheet names, ranges, criteria and column references for your own file.

Why does my formula return an error?

The most common causes are mismatched ranges, missing quotes around text criteria, blank source data, or references that do not match your sheet layout.