SUMIFS Multi-Condition Sums in Excel

Sum values across multiple departments, dates, or cost centers using SUMIFS in Excel. Tutorial for payroll, sales totals, and expense tracking.

Syntax & Formula

=SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)

Unlike SUMIF, SUMIFS puts the sum_range first, followed by pairs of criteria_range and criteria.

Workplace Example

=SUMIFS(Sales[Amount], Sales[Region], "Gauteng", Sales[Month], "December")

Common Mistakes to Avoid

Criteria ranges that differ in size or orientation from the sum_range, resulting in a #VALUE! error.

Practise this in the spreadsheet simulator