SUMIF Greater Than In Google Sheets

What Is SUMIF Greater Than In Google Sheets?

SUMIF greater than in Google sheets is a function used to find the total based on conditions. In Google sheets, we can add up numbers based on conditions. SUMIF is a default function in Google sheets which we can use to find results based on conditions which are greater than, equal to or lower than the values.

For example, consider the below table showing sample and data in columns A, and B respectively.

Now, let us use the SUMIF Google sheets function to find the total or the sum of values which is greater than 1.

To start with, we need to insert the data in the spreadsheet. In this example, the data is available in the cell range A1:B5. Next, select the cell where we want to find the result. In this example, it is cell B7. Next, insert the SUMIF function in Google sheets.

So, the complete formula is =SUMIF(B2:B5,”>1″,B2:B5)

Press Enter key. We will be able to see the result in cell B7 as shown in the below image.

In this article, we can find the result using SUMIF Google sheets function with detailed examples.

Syntax

The formula of SUMIF function in Google sheets is =SUMIF(range,criterion,[sum_range])

where,

1. Range is the cell range for which we need to find the total
2. Criterion is the condition with which users need to find the sum
3. Sum_range is the range showing the cells we need to find the total if condition is ignored

Both range and criterion are mandatory arguments. Sum_range is the only optional argument.

How To Use SUMIF Greater Than In Google Sheets ?

The steps to use SUMIF function with greater than condition in Google sheets are:

Step 1: To start with, we need to insert the data in the spreadsheet. Next, select the cell where we want to find the result.

Step 2: Next, insert the SUMIF function in Google sheets along with “>” condition in the argument.

Step 3: Press Enter key.

We will be able to see the result in the active cell.

Likewise, we can find the result using SUMIF function in Google sheets.

Examples

Example #1 – SUMIF Greater Than 0

For example, consider the below table showing name and projects in columns A, and B respectively.

Now, let us use the SUMIF Google sheets function to find the total or the sum of values which is greater than 0.

The steps are:

Step 1: To start with, we need to insert the data in the spreadsheet. In this example, the data is available in the cell range A1:B9. Next, select the cell where we want to find the result. In this example, it is cell B11.

Step 2: Next, insert the SUMIF function in Google sheets.

So, the complete formula is =SUMIF(B2:B9,”>0″,B2:B9)

Step 3: Press Enter key.

We will be able to see the result in cell B11 as shown in the below image.

Likewise, we can find the result using SUMIF function in Google sheets with greater than condition.

Example #2 – SUMIF Greater Than Or Equal To

For example, consider the below table showing products and quantity in columns A, and B respectively.

Now, let us use the SUMIF Google sheets function to find the total or the sum of values which is greater than or equal to 5.

The steps are:

Step 1: To start with, we need to insert the data in the spreadsheet. In this example, the data is available in the cell range A1:B9. Next, select the cell where we want to find the result. In this example, it is cell B11.

Step 2: Next, insert the SUMIF function in Google sheets.

So, the complete formula is

Step 3: Press Enter key.

We will be able to see the result in cell B11 as shown in the below image.

Likewise, we can find the result using SUMIF function in Google sheets with greater than or equal to condition.

Example #3 – SUMIF Greater Than – Cell References

For example, consider the below table showing region and data in columns A, and B respectively.

Now, let us use the SUMIF Google sheets function to find the total or the sum of values which is greater than 20 using cell reference.

The steps are:

Step 1: To start with, we need to insert the data in the spreadsheet. In this example, the data is available in the cell range A1:B5. The condition is available in the cells A7 and B7. Next, select the cell where we want to find the result. In this example, it is cell B8.

Step 2: Next, insert the SUMIF function in Google sheets.

So, the complete formula is =SUMIF(B2:B5,”>”&B7,B2:B5)

Step 3: Press Enter key.

We will be able to see the result in cell B8 as shown in the below image.

Likewise, we can find the result using SUMIF function in Google sheets with greater than condition using cell reference.

Now, we have learned how to use SUMIF Greater than in Google sheets with examples.

Important Things To Note

1. SUMIF function in Google sheets is used to find the total or sum of data with conditions.
2. We need to mention the criterion or the condition with double quotes (“”) correctly to avoid errors.
3. The condition can be used to find the total of greater than, equal to, lesser than, greater than or equal to, lesser than or equal to or not equal to in SUMIF Google sheets function.

Frequently Asked Questions (FAQs)

Download Template

This article must help understand the SUMIF Greater Than In Google Sheets with its formula and examples. You can download the template here to use it instantly

Recommended Articles

Guide to What is SUMIF Greater Than In Google Sheets. We learn its syntax & how to use it to find the sum under conditions with examples. You can learn more from the following articles. –

Convert Time To Decimal In Google Sheets

Sunburst Chart In Google Sheets

VLOOKUP Partial Match In Google Sheets