Get instant live expert help with Excel or Google Sheets “My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

#### Post your problem and you'll get expert help in seconds

Your message must be at least 40 characters
Our professional experts are available now. Your privacy is guaranteed.

# Using the SUMIF Function for Adding Between Two Values

We often need to sum values from a table based on a certain condition. The SUMIFS function is the perfect solution for this problem. In this tutorial, we will step through how to sum values based on a specific condition.

Figure 1. Final result

## Syntax of the SUMIFS formula

`=SUMIFS(sum_range, criteria_range1, criteria1, criteria_range2, criteria2)`

The parameters of the SUMIFS function are:

• sum_range – a range with values which we want to sum
• criteria_range1 – a range where we want to set our first condition
• criteria1 – the first condition for summing the values
• criteria_range2 – a range where we want to set our second condition
• criteria2 – the second condition for summing the values

## Setting up Our Data for the SUMIFS Function

Our table consists of 3 columns: “Delivery Number” (column B), “Delivery Date” (column C) and “Amount” (column C). In cells G2 and G3, we specify a value range (lower and upper limits), while in cell G4 we want to get a sum between values.

Figure 2. Data that we will use in the SUMIFS example

## Sum Amount Between Two Values Using the SUMIFS Function

We want to sum all amounts from column D that are between the lower and upper limit (\$500 and \$1,000)

The sum_range is D3:D9. Criteria1 is “>”&G2. Criteria2 is “<”&G3.

To apply the SUMIFS function, we need to follow these steps:

• Select cell G4 and click on it
• Insert the formula: =SUMIFS(D3:D9,D3:D9,”>”&G2,D3:D9,”<“&G3)
• Press enter

Figure 3. Using the SUMIFS function to sum between two values

We see in this example that the formula returns all the amounts that are between \$500 and \$1,000. As you can see, rows 5 (\$700) and 6 (\$650) meet both conditions, so correspondings amounts are summed. Finally, the sum in the cell G4 is \$1,550.

Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.

### Did this post not answer your question? Get a solution from connecting with the expert. 