Two conditions at once with SUMIFS

SUMIFS does what SUMIF does, with any number of conditions. It also reverses the argument order: the range to add comes first, then each range-and-condition pair. =SUMIFS(D2:D11,A2:A11,"North",C2:C11,">15").

That inconsistency between SUMIF and SUMIFS is a genuine wart in Excel and a common source of #VALUE!. Many people use SUMIFS for everything, even with one condition, simply to avoid having to remember two orders.