Last Updated on November 1, 2023 by Jake Sheridan
In this tutorial, you will learn how to use the SUMPRODUCT in Google Sheets.
How to Use SUMPRODUCT Formula in Google Sheets
The SUMPRODUCT formula is a powerful and versatile tool that can help you answer complex questions with your data.
It is often used to calculate total prices given a quantity and unit price or the sum of values that meet certain criteria.
In this guide, we’ll show you how to use the SUMPRODUCT formula in Google Sheets.
We’ll explain how the formula works, and provide a few examples of how it can be used.
How to Apply the SUMPRODUCT Function in Google Sheets
Here’s how to apply the SUMPRODUCT function in Google Sheets.
Select an empty cell to place the output of the SUMPRODUCT function.
Type “=SUMPRODUCT” to start the function.
Indicate the ranges to use for the SUMPRODUCT function.
In this example, we want to find the product of the unit cost and quantity per row and find the sum of each of these produces.
The SUMPRODUCT function can support two or more ranges as arguments
In the example above, we were able to find the total discount after adding the values in the range D2:D5.
We can also add a range of TRUE and FALSE values as an argument for SUMPRODUCT. Since FALSE is equivalent to 0, this essentially removes any rows which have a FALSE value.
In the example above, we used the In Stock column for our SUMPRODUCT function to eliminate costs for items not currently in stock.
This guide should be everything you need to use the SUMPRODUCT formula in Google Sheets.
You may make a copy of this example spreadsheet to test it out on your own.
More basic math formulas in Google Sheets:
- AVERAGE Function
- MAX Function
- MIN Function
- FLATTEN Function
- GROWTH Function
- Transpose Data
- SORT Function
- How To Round
- How To Multiply
- How To Divide
- How To Subtract
- Round Down
- Add Cells
- Multiply Cells
- Subtract Cells
- Find Median
- Find Quartiles
- Automatically Add Numbers
- Find Mean
- Standard Deviation
- Find Average
- Find Range
- Find Variance
- T Test
- Use Pi In Google Sheets
- How To Square
- Square Root
- Sum Columns or Rows
- How To Create A Function
- How To Create Formula