Learn Sumifs Function In Google Sheets

Learn Sumifs Function In Google Sheets

Google Sheets has nearly 2 billion monthly users who are far exceeding the number of users using Microsoft word itself. Google Sheets is rapidly growing, and more people are using Google Sheets because of the amazing features it offers to users. 

First of all, Google Sheets is completely free, and it doesn’t require downloading or installing any application to work. You can use any of your web browsers to access Google Sheets and start editing. It is the best application when it comes to data editing or modifying. 

There are countless features that helped millions of users. One of the unique features that Google Sheet has to offer is the function or fx. It allows the users to break down a complicated process into simple and easy tasks. 

Using some formulas, you can increase the speed of your workflow and won’t have to manually calculate data in it. The days of calculating thousands of data using a calculator are over. With Google Sheets, you can use simple formulas with no mathematical background to finish the task within a few minutes. 

In this post, we are going to see a specific function called SUMIF, which is a very useful function. 

Using SUMIFS Function To Calculate

SUMIF function is used to calculate a specific type of data. For example, we are going to use the SUMIF function to calculate the value of different types of element users. You can see in the picture that there are nine rows, nine users, and three different styles of elements. 

As you can see, the data are mixed up. Fire, wind, and water style users are mixed up. We don’t know the total strength of the fire, wind, and water style users individually. If the first three rows consisted of fire style users, the next three wind style, and the last three were water style users, we can calculate the total strength of these individual groups easily. We could have just selected the rows with fire styles users and seen the total sum near the Explore feature at the right side bottom of the sheet. 

In this instance, we can calculate them individually because there are only nine rows. What if it has 90 or 900 rows with jumbled users? It would be impossible to calculate the strength of different types of users manually. 

This is where the SUMIF function comes into play. We can calculator the total strength of fire, wind, and water styles users separately using this function. Follow these steps to calculate the total strength of different element users.

1. First, let us calculate the total sum or total strength of fire styles users. To do that, go to a new column with no occupied cells. Make a list like shown in the image. Use two columns to write the type and use the function to calculate the total sum. 

2. The total in column C shows the strength of individual users of their own type of elements they use, which is shown in column B. Go to column F and type =SUMIF function in F2 near the fire style. 

3. Now, we are going to define the input so that the function can calculate the total sum. We are going to calculate all the rows that are filled with data. The data are available from the 2nd row to 10 throws. And the columns that we require are the B and C columns. So, write =SUMIF(B2:B10, …). When we specify B2:B10, it tells the function to take data from the B2 to B10 rows. 

4. Now, we should define what style should the function should calculate. We are going to calculate the strength of fire-style users first. So, we are going to input the fire styles in E2. Write =SUMIF(B2:B10, E2…).

5. As the final step, we should define the column and rows where the strength of individuals are available. The strength is in column C. So write =SUMIF(B2:B10, E2, C2:C10) and press Enter. 

As you can see, it has calculated the total strength of fire styles users. 

You can double click on the Fill Handle to calculate the total strength of water and wind styles users too.