=SUMIFS(sum_rng, crit_rng1, crit1, crit_rng2, crit2)

Related formulas

Sum if equal to either x or y

Sum if date is between

Count if two criteria match

Sum sales in last 30 days by ID

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:

=SUMIFS(D4:D11,B4:B11,"blue",C4:C11,">15")

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.

=SUMIFS(sum_rng, crit_rng1, crit1, crit_rng2, crit2)