Several conditions: SUMIFS

How much did the large website orders, the ones over $5,000, bring in? This question has two conditions at once: where the order came from and how much it was. Here are the orders you need to answer it from:

SUMIF can't handle this: it checks only one condition. For several conditions, there's the SUMIFS function.

What to add up comes first

The first argument of SUMIFS is the range to add up. After it come pairs: "where to check, what condition". Conditions are written the same way as in SUMIF: text and comparison signs go in quotes.

=SUMIFS(B2:B9,A2:A9,"Website",B2:B9,">5000")

Here's what each part of the formula takes:

A row gets into the total only if all the conditions are true. There can be more conditions: each one is added at the end as another "where to check, condition" pair.

The range to add up: last or first

SUMIF and SUMIFS have the same parts, just in a different order. Here's the same total of website orders written with both functions, with parts that play the same role shown in the same color:

SUMIFS works with a single condition too: the bottom formula calculates exactly the same thing as the top one. So you can always write just SUMIFS and never have to remember where each function wants the amounts.