SUMIFS
Math FormulasMaster SUMIFS for summing with multiple conditions. Learn to combine criteria for powerful conditional calculations.
Syntax
SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)Parameters
sum_rangeThe range of cells to sum
criteria_range1The first range to evaluate
criteria1The first condition
criteria_range2, criteria2Additional range/criteria pairs (optional)
Examples
=SUMIFS(C:C, A:A, "Sales", B:B, ">1000")Sum column C where A='Sales' AND B>1000
=SUMIFS(D:D, A:A, E2, B:B, ">="&F2)Sum with cell references as criteria
Common Errors
Returns 0 if no matches
All ranges must be same size
Pro Tips
All criteria must be met (AND logic)
For OR logic, use multiple SUMIFS added together
Date criteria need proper formatting
Related Functions
Need Help with SUMIFS?
Describe your specific use case and our AI will generate the perfect SUMIFS formula for you.
Generate SUMIFS Formula