Basic SUMIFS Syntax
=SUMIFS(sum_range, criteria_range1, criteria1, criteria_range2, criteria2, ...)
Example: Sum Sales by Region and Status
To sum column D where column A = "West" and column C = "Completed": =SUMIFS(D:D,A:A,"West",C:C,"Completed")
Date Range Criteria
Sum values between two dates: =SUMIFS(D:D,C:C,">="&DATE(2026,1,1),C:C,"<="&DATE(2026,6,30))
Wildcard Patterns
Use * for partial text matching: =SUMIFS(D:D,A:A,"*North*") sums all rows where column A contains "North".
Excel vs Google Sheets Differences
SUMIFS works identically in both platforms. However, in Google Sheets you can wrap it in ARRAYFORMULA for dynamic ranges, while Excel handles this natively with dynamic arrays.