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 sum a column

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

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 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.

How-to

How to sum the top N values

Add up the largest few numbers in a range using LARGE. Here we total the top 3 — the same in both apps.

Related

SUMIFSUMIFSCOUNTIF

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

Last reviewed: