Sign in Subscribe

Google Sheets Functions

How to Use SUMIFS Function in Google Sheets?

Mathematics is pretty easy when working with Google Sheets. Addition, subtraction, multiplication. While performing operations on these, the functions work with the whole column or the cell range you specify. What if we want to give a condition at the same time while doing the addition? With SUMIF we can give a condition, but with SUMIFS we can add under more than one condition. Let's move on to the explanation through examples.

Where is SUMIFS used?

We have a sales data table. The table contains text, numeric values, and dates. Let's move on to the description with the examples.

Using SUMIFS in the text tables

Using text columns in our sales table, we will give multiple conditions and get a total.

Category = Art, State=Florida

We will get the sum of the sales that meet these conditions.

=SUMIFS(B:B,A:A,"Art",D:D,"Florida")

B:B→ The range of cells I want the total to be
A:A→ The range of cells to search for my first condition
“Art”→ The first condition
D:D→ Range of cells to search for my second condition
“Florida”: Second condition

It gave it directly because it is the only line that satisfies the two conditions. If there was another row that satisfies the condition, it would be given as a total with it.

Using SUMIFS in numeric tables

We wonder how many products are there in the appliances category with a profit of more than 20.

=SUMIFS(B:B,A:A,"Appliances",E:E,">20")

B:B→ The range of cells I want the total to be
A:A→ The range of cells to search for my first condition
“Appliances”→ The first condition
E:E→ Range of cells to search for my second condition
“>20”→ Second condition

Using SUMIFS in date tables

We wonder about the total profit of sales more than 3 after 6.12.2017

=SUMIFS(E:E,C:C,">6.12.2017",B:B,">3")

E:E → The range of cells I want the total to be
C:C→ The range of cells to search for my first condition
“>6.12.2017”→ The first condition
B:B→ Range of cells to search for my second condition
“>3”→Second condition

Read next

How to Use REGEXMATCH Function in Google Sheets?

How to Use REGEXMATCH Function in Google Sheets?

Searching within tables is a common task when working with Google Sheets. With the REGEXMATCH function, we can easily find the answer to the question of whether there is an exact match for the word we are looking for in a table. We can easily search with 'Find and replace'.

How to Use VLOOKUP Function in Google Sheets?

How to Use VLOOKUP Function in Google Sheets?

When working with Google Sheets, we can have multiple tables, multiple sheets, or multiple workbooks. Among these, we may need to work with identical columns and corresponding columns. For example, product codes, product names. We may need to use them on multiple pages. Instead of moving columns every time, we

How to Use the UNIQUE Function in Google Sheets?

How to Use the UNIQUE Function in Google Sheets?

When working with Google Sheets, we may have written the same data in our worksheet more than once. If there are few rows and columns, we can handle this one by one. But this becomes very difficult when working with very large tables. Suppose there are multiple duplicate data in

How to Use COUNTIFS Function in Google Sheets?

How to Use COUNTIFS Function in Google Sheets?

Searching worksheets can be done manually with little data. If you have a large table in your worksheet, if you have multiple worksheets or even workbooks connected to each other, this work becomes quite tiring. For example, you have a supermarket dataset. You wonder how many of 'x' items are

How to Use ROUND Function in Google Sheets?

How to Use ROUND Function in Google Sheets?

When working with Google Spreadsheets, our tables can have decimals. Working with them is pretty easy in Google Spreadsheets. However, we often want to get rid of them for ease of reading and to avoid image crowding when displaying in graphics. We use the Round function to perform this function.

How to Use SPARKLINE Function in Google Sheets?

How to Use SPARKLINE Function in Google Sheets?

When working with Google Sheets, we sometimes show our table with the help of graphs for ease of reading. Graphs help us a lot for both ease of reading and analysis. Well, imagine that you made these graphs for the rows only, not for the whole table. This is great.

How to Use IMPORTXML Function in Google Sheets?

How to Use IMPORTXML Function in Google Sheets?

With Google Spreadsheets, we can easily retrieve data from the pages we browse on the internet. We can take data from a second-hand site we look at, examine it, and even show it on a graph. All we need to know here is the function syntax. The IMPORTXML function requires

How to Use IMPORTRANGE Function in Google Sheets?

How to Use IMPORTRANGE Function in Google Sheets?

When working with Google Sheets, we can have multiple tables, multiple sheets. We may need to use the same data on different pages. You may think of getting data with copy-paste. But this would not be a tiring and continuous practice. We can easily make this application with IMPORTRANGE. If

How to Use IMAGE Function in Google Sheets?

How to Use IMAGE Function in Google Sheets?

When working with Google Sheets, we can easily add images to our sheet. We can fit it inside the cell or add it on the page. The syntax is pretty simple. Let's explain the syntax and how the function works through the example below. What is the syntax of the

How to Use GOOGLEFINANCE Function in Google Sheets?

How to Use GOOGLEFINANCE Function in Google Sheets?

With the GOOGLEFINANCE function, we can easily transfer our data from the Google finance web application to our worksheet. We can receive real-time foreign exchange and financial information daily, and we can track stocks. In addition, we can get historical securities data, show them with graphics and easily share what