How to Use SUMIFS in Google Sheets
SUMIFS adds values that meet multiple criteria. Unlike SUMIF which handles one condition, SUMIFS can evaluate several conditions at once.
Understand SUMIFS Syntax
SUMIFS(sum_range, criteria_range1, criterion1, [criteria_range2, criterion2, ...]). The sum_range is first, followed by pairs of ranges and criteria.
Sum with One Condition
Use =SUMIFS(C1:C100, A1:A100, "Active") to sum column C where column A equals "Active".
Add Multiple Conditions
Use =SUMIFS(C1:C100, A1:A100, "Active", B1:B100, ">100") to sum values that are both Active and greater than 100.
Use Cell References in Criteria
Use =SUMIFS(C1:C100, A1:A100, E1, B1:B100, ">"&F1) to make criteria dynamic by referencing other cells.
💡 Use & to combine comparison operators with cell references.
Try These Templates
Frequently Asked Questions
What is the order of arguments in SUMIFS vs SUMIF?
SUMIF puts criteria first: SUMIF(range, criterion, [sum_range]). SUMIFS puts sum_range first: SUMIFS(sum_range, criteria_range1, criterion1).
Can SUMIFS handle OR logic?
No. SUMIFS uses AND logic. For OR logic, add multiple SUMIF formulas together.