How To Use Google Sheets SUMIF Function

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

  1. Open either a new or an old Google Sheets file.
  2. 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.
  3. 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.
  4. Click on the cell where you want the total of your data to show up.
  5. =SUMIF(” goes in the cell. This is where the SUMIF formula will begin.
  6. 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.
  7. After the range of cells, type a “,“.
  8. 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.
  9. After the criteria, add another comma “,“.
  10. 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.

How To Use Google Sheets SUMIF Function

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.


Why is my Sumifs formula not working?

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.

How do you use Sumifs function?

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.”

Can you use or in a Sumifs formula?

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.

Editorial Staff
Editorial Staff
The Bollyinside editorial staff is made up of tech experts with more than 10 years of experience Led by Sumit Chauhan. We started in 2014 and now Bollyinside is a leading tech resource, offering everything from product reviews and tech guides to marketing tips. Think of us as your go-to tech encyclopedia!


Please enter your comment!
Please enter your name here

Related Articles

Best Telemedicine Software: for your healthcare practice

Telemedicine software has transformed my healthcare visits. It's fantastic for patients and doctors since they can obtain aid quickly. I...
Read more
I love microlearning Platforms in today's fast-paced world. Short, focused teachings that engage me are key. Microlearning platforms are great...
Think of a notebook on your computer or tablet that can be changed to fit whatever you want to write...
As of late, Homeschool Apps has gained a lot of popularity, which means that an increasing number of...
From what I've seen, HelpDesk software is essential for modern businesses to run easily. It's especially useful for improving customer...
For all of our important pictures, stories, and drawings, Google Drive is like a big toy box. But sometimes the...