When you ask people what Google Sheets functions they know about, the most common answers you’ll get are SUM and IF. But what if I tell you that Google Sheets has a feature that combines the two? The SUMIF feature will become one of your favorites after we explore how it can streamline your workflow.
SUMIF allows you to combine values that meet the criteria you define. Based on this, you can already guess that the SUMIF function requires two parameters: the range of numbers you want to sum, and the criteria that will determine which of those numbers to include.
By using the SUMIF function, you can save a lot of time without having to sort and filter your data. You are also more assured of the accuracy of your data, as the combination is performed without manual intervention. Now that you are familiar with this feature, here are the steps to use it.
Advertising
How to use the SUMIF function on Google Sheets
1. Open your spreadsheet and click on the cell where you want the output to appear.
2. You have two options for starting the SUMIF function. On the selected cell, you can access Insert > Function > Math > SUMIF in your main header toolbar. You can also type =SUMIF( on your cell.
3. After running the function, you need to enter the first parameter range by highlighting your data table.
4. Next, type a comma (,) and enter your criteria.
5. A third optional parameter is the sum_range. You only need to use the sum-range parameter if your values are different from your range. Using sum_range, Sheets compares your criteria to your range, then adds values from the same row of range items that match your criteria.
6. Finally, press Walk in on your keyboard. Your output will appear in the cell.
