Some of the best functions in Google Sheets are those that help you summarize and group data. Today, we will take a closer look at one of these functions, SUMIF, which is a powerful way to add up cells based on certain conditions. Before we look at the examples of syntax and formulas, we want to make a few important points of how To Use Google Sheets SUMIF Function.
Google Sheets has two functions, SUMIF and SUMIFS, that add up numbers based on conditions. The first one only checks one condition, while the second one can check several conditions at once. In this article we will mentioned some steps how To Use Google Sheets SUMIF Function.
How To Use Google Sheets SUMIF Function
- Open either a new or an old Google Sheets file.
- Fill out the worksheet with your information. For example, you might have a list of sales with columns for the date, product, quantity, and price.
- Choose the criteria you will use to summarize your data. For instance, you might want to add up all the sales for a certain product or for a certain time period.
- Click on the cell where you want the total of your data to show up.
- “=SUMIF(” goes in the cell. This is where the SUMIF formula will begin.
- Choose the cells in which you want to look for the criteria. For example, if you want to add up how many of a certain product were sold, you would choose the column with the product names.
- After the range of cells, type a “,“.
- Type in the criteria you want to use to add up the numbers. For example, if you want to add up the sales of a product called “Boots,” you would put “Boots” in quotation marks.
- After the criteria, add another comma “,“.
- Choose the group of cells that has the numbers you want to add up. For instance, if you wanted to add up the sales for the “Boots” product, you would choose the column with the sales numbers.
What Is the Purpose of SUMIF Function?
SUMIF is really just a combination of two of Google Sheets’ simpler functions. The functions SUM and IF. It works the same way as Excel’s SUMIF function. As the names of the two functions suggest, this function looks through a range of cells and finds the ones that match a condition set by the user.
If this is true, the values in those cells are taken out and added. Before going on, you might want to learn how to do SUM functions and what the IF function is. If you understand these, you will be better able to use the SUMIF function.
With the SUMIF function, you don’t have to manually type in the two formulas because you can get the same result with just one formula. This saves you time, trouble, and the chance of making a mistake.
As you know that the SUMIF function deals with numbers that can be summed up. At first, you have to check the sum range whether it is in the proper number format or not. While importing data from other sources, facing uneven data formats is not so rare.
If you want, you can apply the criteria to one range and sum the corresponding values in a different range. For example, the formula =SUMIF(B2:B5, “John”, C2:C5) sums only the values in the range C2:C5, where the corresponding cells in the range B2:B5 equal “John.”
The SUMIF function in Excel is used to sum values based on a single condition or criteria. However, if we want to sum values based on multiple criteria where at least one of the conditions are met, we use the SUMIF with OR logic.