What SUMIFS does
SUMIFS adds values that meet more than one condition. It is useful when you need totals filtered by multiple dimensions such as product and month, region and rep, or customer and status.
Practical examples
Sum by category and month
=SUMIFS($D$2:$D$100,$A$2:$A$100,"North",$B$2:$B$100,"Jan")
This formula adds only the values where both conditions are true.
Combine cell-driven filters
=SUMIFS($D$2:$D$100,$A$2:$A$100,F2,$B$2:$B$100,G2)
This is a strong pattern for dashboards and reusable summary tables.
Common mistakes and notes
SUMIFS uses AND logic
Every condition must be satisfied. If you need OR-style logic, you usually need multiple formulas or a different structure.
Range sizes must line up
The sum range and criteria ranges should all cover the same shape.