Let’s take a look.
SUMIFS has three required arguments:sum_range, criteria_range1,andcriteria1.
After that, you could enter additional range and criteria pairs to add additional conditions.
When you use a number without an operator, there’s no need to use double quotes.
Excel returns “30”.
The next example also requires two pair of range and criteria.
One to test for numbers equal to 10, and the other to test for a color of blue.
The final two problems involve summing numbers where the color is blueorpurple.
However, you’ll then need to wrap the entire SUMIFS function inside aSUM function.
The criteria is “>1/1/2013”.
In the next example, “amount” is again thesum_range.
Thecriteria_range1is the range “product” and the criteria is just “coffee” in double quotes.
In the last example, “amount” is again thesum_range.
