# How To Do a Conditional Sum in Google Sheets

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!