Sum total sales based on quantity & price in Excel and Google Sheets

=SUMPRODUCT(A2:A5,B2:B5)

A2:A5 = quantity range; B2:B5 = price range

Check below for a detailed explanation with pictures and how to use formulas in Excel and Google Sheets.

Sum total sales based on quantity & price in Excel

How to sum total sales based on quantity & price in Excel?

SUM TOTAL SALES BASED ON QUANTITY & PRICE — EXCEL FORMULA AND EXAMPLE

=SUMPRODUCT(A2:A5,B2:B5)

  • A2:A5 = quantity range

  • B2:B5 = price range

Sum total sales based on quantity & price in Google Sheets

How to sum total sales based on quantity & price in Google Sheets?
Sum total sales based on quantity & price in Google Sheets

SUM TOTAL SALES BASED ON QUANTITY & PRICE — GOOGLE SHEETS FORMULA AND EXAMPLE

=SUMPRODUCT(A2:A5,B2:B5)

  • A2:A5 = quantity range

  • B2:B5 = price range

Other widely used Excel and Google Sheets formulas explainedOthers FormulasDate and time functionsNumber based criteriaText-based criteriaExtract functions