Skip to content
FormulaCraft

SUMPRODUCT

SUMPRODUCT multiplies corresponding cells across ranges and adds the products. It is perfect for quantity × price totals, weighted averages, and conditional counts.

Topic:SUM & aggregation
Excel
=SUMPRODUCT(B2:B100, C2:C100)
Google Sheets
=SUMPRODUCT(B2:B100, C2:C100)

Try it with your data

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

Sample data — click any cell to edit

Runs server-side · free · no signup

How it works

  1. 1B2:B100 and C2:C100 are multiplied row by row.
  2. 2The products are added into a single total.
  3. 3The ranges must be the same size.

Need a version for your data?

Try: “Multiply quantity in B by price in C for each row and total it”

More on SUM & aggregation

See all →
Reference

SUBTOTAL

Aggregate a range (sum, average, count…) while ignoring other SUBTOTALs and, optionally, hidden rows. Ideal under filters.

How-to

How to calculate a 30-day rolling sum

Sum the 30 calendar days ending on a chosen date with SUMIFS, including timestamps on the final day and excluding future rows.

Error fix

Fix 0

SUM returns 0 or the wrong total in Excel and Google Sheets — fix numbers stored as text, filtered ranges, manual calculation mode, and circular references.

How-to

How to sum a column

Add up an entire column with SUM. Total a whole column or a fixed range — identical in Excel and Google Sheets.

How-to

How to create a running total

Build a cumulative running total with a SUM and a clever anchored reference that grows as you copy it down. Works in both apps.

How-to

How to sum values by month

Total amounts that fall in a given month with SUMIFS and two date bounds. Works the same in Excel and Google Sheets.

Related

SUMIFSUMIFSCOUNTIF

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

Last reviewed: