How To Do a Conditional Sum in Google Sheets

Last Updated on September 6, 2023 by Jake Sheridan

In this tutorial, you will learn how to do a conditional sum in Google Sheets.

How To Do a Conditional Sum in Google Sheets

In many cases, you may need to sum up cells in a spreadsheet based on certain conditions. For example, you may want to sum up all the values in a column that have a certain text in a particular field.

In Google Sheets, you can use conditional sums to quickly and easily calculate the sum of cells that meet certain criteria. This can be a great way to quickly analyze your data and get the information you need.

In this guide, we will show you how to do a conditional sum in Google Sheets by using the SUMIF function.

How to Calculate a Conditional Sum in Google Sheets

Here’s our step-by-step guide on how to calculate a conditional sum in Google Sheets.

Step 1

First, open the document with the data you want to find a conditional sum for.

In this example, we want to find a conditional sum of sales data.

Step 2

Start with the SUMIF function and select the range you want to use to decide whether to include or not in the conditional sum.

Step 3

Next, provide the criteria to consider when checking the range mentioned in the first argument.

Step 4

Lastly, provide the range you want to find the total of.

Step 5

Hit the Enter key to evaluate the SUMIF function.

In this example, we find out that a total of 123 sales were made in entries with the Mobile Phone category.

In our table above, we’ve copied the same SUMIF formula to total sales under different categories.

Summary

This guide should be everything you need to learn how to do a conditional sum in Google Sheets.

Click this link to make a copy of this sample document to try doing it yourself!