How to Use SUMPRODUCT Formula in Google Sheets

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.

Step 1

Select an empty cell to place the output of the SUMPRODUCT function.

Step 2

Type “=SUMPRODUCT” to start the function.

Step 3

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.

Step 4

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.

Step 5

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.

Summary

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.