Quick, clean, and to the point

Sum if multiple criteria

Excel formula: Sum if multiple criteria
Generic formula 
=SUMIFS(sum_rng, crit_rng1, crit1, crit_rng2, crit2)

If you need to sum numbers based on multiple criteria, you can use the SUMIFS function.

In the example shown, the formula in G6 is:


How this formula works

The first range (D4:D11) are the cells to sum, called the "sum range".

Criteria are supplied in pairs...(range / criteria).

The first criteria pair is (B4:B11 / "blue"). This means cells in B4:B11 must equal "blue".

The second criteria pair is (C4:C11 / ">15"). Cells in C4:C11 must *also* be > 15.

These cells in the sum range will only be summed when all criteria pass.

Dave Bruns

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.