How to use SUMIF to add values higher than a certain amount
This is yet another SUMIF function Example. This time we are going to use it to add only the values that are above a certain amount. For this example, we are going to add values above $500. This formula will add the cells that are specified by a given criteria. Here is how we will achieve this.
How to sum specified values
- In cells A2:A11 enter the different customer names.
- Enter the costs of each customer incurs in cells B2:B11.
- In cell D1 enter $500 as the given criteria. Remember, the SUMIF syntax is: SUMIF(range, criteria, sum_range)
- Select cell D2 and type the following formula: =SUMIF(B2:B11,”>” & D1).
- Press Enter.
- If the criteria is not linked to a cell reference, simply use this formula: =SUMIF(B2:B11,”>500″).
You should now be set!
- How to use the SUMIF function within a formula in Excel
- How to use the COUNTIF function to count values in Excel
- How to add months to a date using the DATE Function in Excel
- Use the RANDBETWEEN function to generate random values in a specified range
- Use the SMALL function to find the smallest values in Excel
