ExamplesFor You
Home / Excel / SUMPRODUCT
✍️ Excel summary examples

SUMPRODUCT Examples in Excel

Learn SUMPRODUCT examples for weighted averages, conditional totals and row-by-row calculations.

Updated 2026-06-125 practical examplesCopy-ready

What it does

SUMPRODUCT multiplies arrays together and returns the sum of the products.

Syntax or pattern

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

5 practical examples

1

Calculate weighted revenue

Multiply quantity by price and total the result.

=SUMPRODUCT(Orders[Qty],Orders[Price])

Avoids helper columns for simple row-by-row math.

2

Weighted average

Calculate weighted average score.

=SUMPRODUCT(Scores[Score],Scores[Weight])/SUM(Scores[Weight])

A classic weighted average pattern.

3

Conditional total

Sum amounts where region is East.

=SUMPRODUCT((Sales[Region]="East")*Sales[Amount])

TRUE/FALSE tests become 1/0 values.

4

Count rows with two conditions

Count rows matching product and region.

=SUMPRODUCT((Sales[Product]=H2)*(Sales[Region]=H3))

A flexible alternative to COUNTIFS.

5

Total by month

Sum amounts for one month using date tests.

=SUMPRODUCT((TEXT(Sales[Date],"yyyymm")=TEXT(H1,"yyyymm"))*Sales[Amount])

Useful when dates are daily but reports are monthly.

Common mistakes to avoid

  • Selecting ranges with different sizes.
  • Using text values where numbers are required.
  • Forgetting how blanks and hidden rows are treated.

Related Excel examples

SUM Examples in ExcelSUMIF Examples in ExcelSUMIFS Examples in Excel📊 All Excel examples

FAQ

Can this formula use Excel Tables?

Yes. Structured references often make summary formulas easier to read.

💡 Useful resources

Here are some ideas for you

Optional resources that may help if you are learning formulas, building reports, or working in spreadsheets often.

  • 📘
    Excel formula books

    Practice formulas with structured examples you can keep beside your desk.

    See ideas
  • ⌨️
    Excel shortcut guides

    Build speed with keyboard shortcuts for selection, formatting and navigation.

    See ideas
  • 🔢
    Numeric keypads

    Helpful if you enter many numbers on a laptop or compact keyboard.

    See ideas
  • 🖥️
    External monitors

    Useful for viewing large worksheets, formulas and reference tables side by side.

    See ideas
  • 📒
    Desk notebooks

    Sketch formula logic, report ideas and table structures before building.

    See ideas
  • 💻
    Laptop stands

    Make long spreadsheet sessions more comfortable and ergonomic.

    See ideas

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