SUMIF With Multiple Criteria In Google Sheets

What Are SUMIF Function With Multiple Criteria?

SUMIF function with multiple criteria is an inbuilt function is Google sheets used to find the sum or total of specific values in a data based on a criteria or criterions. This function helps users find the sum of individual data in huge data sets.

Using this function, we can find the sum of values with multiple criterions also, based on the user’s requirements.

For example, consider the below table showing products, amount and the status in columns A, B and C, respectively. Cells F1 and F2 shows the first and second criterions.

Now, let us learn how to find the total of product showing first criteria ‘Apple’ and second criteria ‘Delivered’.

To begin with, insert the cell range in the spreadsheet. In this example, the data is available in the cell range A1:C13. Now, select the cell where we want to insert the formula. In this example, it is cell F3. Next, insert the SUMIFS formula in Google sheets. So, the complete formula is =SUMIFS(B2:B13, A2:A13, F1, C2:C13, F2). Now, press Enter key. We can see the result in cell F3 as shown in the below image.

In this article, let us learn how to use SUMIF function in Google sheets with detailed examples.

SUMIF Multiple Criteria Syntax

The syntax or formula of SUMIF Multiple criteria is

=SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2, …])

where,

• sum_range is the range of cells which we want to add in the formula
• criteria_range1 is the range of cells showing the first criteria to be added in the formula.
• criteria1 is the first criterion we need to check in the cell range.
• criteria_range2 is the range of cells showing the second criteria
• criteria2 is the second criterion which we have to include in the formula.

How To Use SUMIF Function With Multiple Criteria?

Let us learn how to use the SUMIF function with multiple criteria with the following steps.

The steps are:

Step 1: To begin with, insert the cell range in the spreadsheet. Now, select the cell where we want to insert the formula.

Step 2: Next, insert the SUMIFS formula in Google sheets.

Step 3: Now, press Enter key.

We will be able to see the result.

Likewise, we can use the SUMIF function in Google sheets.

Examples Of SUMIF Function With Multiple Criteria

Let us learn how to use the SUMIF function with multiple criteria with detailed examples.

Example #1 – One Criterion From Each Column

For example, consider the below table showing items, sales and region in columns A, B and C, respectively. Cells F1 and F2 shows the first and second criterions.

Now, let us learn how to find the total of product showing first criteria ‘Pens’ and second criteria ‘North’.

The steps are:

Step 1: To begin with, insert the cell range in the spreadsheet. In this example, the data is available in the cell range A1:C13. Now, select the cell where we want to insert the formula. In this example, it is cell F3.

Step 2: Next, insert the SUMIFS formula in Google sheets.

So, the complete formula is =SUMIFS(B2:B13, A2:A13, F1, C2:C13, F2)

Step 3: Now, press Enter key.

We can see the result in cell F3 as shown in the below image.

Likewise, we can use the SUMIF function with multiple criterions in Google sheets.

Example #2 – One Or More Criteria From Either Column

For example, consider the below table showing names, marks and the exam status in columns A, B and C, respectively. Cells F1 and F2 shows the first and second criterions.

Now, let us learn how to find the total of product showing first criteria ‘Andy’ and second criteria ‘Pass’.

The steps are:

Step 1: To begin with, insert the cell range in the spreadsheet. In this example, the data is available in the cell range A1:C13. Now, select the cell where we want to insert the formula. In this example, it is cell F3.

Step 2: Next, insert the SUMIFS formula in Google sheets.

So, the complete formula is =SUMIFS(B2:B13, A2:A13, F1, C2:C13, F2)

Step 3: Now, press Enter key.

We can see the result in cell F3 as shown in the below image.

Likewise, we can use the SUMIF function with multiple criterions in Google sheets.

Example #3

For example, consider the below table showing products, amount and the status in columns A, B and C, respectively. Cells F1 and F2 shows the first and second criterions.

Now, let us learn how to find the total of product showing first criteria ‘Keyboard’ and second criteria ‘Available’.

The steps are:

Step 1: To begin with, insert the cell range in the spreadsheet. In this example, the data is available in the cell range A1:C13. Now, select the cell where we want to insert the formula. In this example, it is cell F3.

Step 2: Next, insert the SUMIFS formula in Google sheets.

So, the complete formula is =SUMIFS(B2:B13, A2:A13, F1, C2:C13, F2)

Step 3: Now, press Enter key.

We can see the result in cell F3 as shown in the below image.

Likewise, we can use the SUMIF function with multiple criteria in Google sheets.

Important Things To Note

• SUMIF with multiple criteria finds the total of particular values in the given data set.
• We can use as many number of criterions as we want to in the formula.
• Remember to include the cell range and criteria in specific arguments to find the accurate total of particular entries in Google sheets.

Frequently Asked Questions

Download Template

This article must help understand the SUMIF Function With Multiple Criteria, with its formula and examples. We can download the template here to use it instantly.

Recommended Articles

Guide to What Are SUMIF Function With Multiple Criteria. Here we discuss how to use SUMIF function with multiple criteria along with its examples. You can learn more from the following articles. –

Count Colored Cells In Google Sheets

Concatenate In Google Sheets

NA Google Sheets