What is SUMIFS?
Adds cells meeting multiple criteria. The most powerful conditional sum function for complex business analysis with multiple filters.
Syntax
=SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)
Example
Formula: =SUMIFS(D2:D10, A2:A10, \
Result: 450
How It Works
Sums values in D2:D10 where A2:A10 equals 'East' AND B2:B10 is greater than 50. All criteria must be met (AND logic). Supports up to 127 criteria pairs.