sumif-google-sheets

How to use SUMIF in Google Sheets

4 min read

Summary

Using SUMIF in Google Sheets helps summarize data by applying conditions, allowing for more targeted and meaningful analysis. It's ideal for filtering and totalling specific data points.

The SUMIF function is especially useful when working with large data sets where you only want to total values that meet certain criteria.

To begin, identify the range of cells you want to evaluate. Then, choose the condition that will determine which cells to include in the sum. For example, if you want to total sales only from a specific region, you can set the region name as your condition.

The basic formula looks like this: =SUMIF(range, criteria, sum_range)

Let’s break it down: Range is where Google Sheets looks for the condition (e.g., a column with regions). Criteria is the condition (e.g., "North"). Sum_range is the group of cells to add (e.g., sales amounts).

Post image

Suppose column A contains region names and column B contains sales. You could write: =SUMIF(A2:A10, "North", B2:B10) This will total the values in B2 to B10 only where the corresponding cell in A2 to A10 is "North".

More Google Workspace tips from Kanbanchi

You can also use comparison operators like >, <, or <>. For instance, =SUMIF(B2:B10, ">100") will add all values greater than 100 in that range.

To make it even more flexible, you can reference a cell instead of typing the criteria. This allows you to change the condition without editing the formula.

Want to try the power of Kanbanchi and Google Workspace?

Start your free trial

Watch to use SUMIF in Google Sheets

Privacy Overview

This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.