All functions / Math

SUMIFS

Adds the cells that meet every one of several conditions.

Syntax

=SUMIFS(sum_range, criteria_range, criteria, [criteria_range1, [criteria_range2], …])

Arguments

• sum_range: The cells to add.
• criteria_range: A range to test.
• criteria: The condition for that range.
• criteria_range (optional): More range/condition pairs.

Example

=SUMIFS(D2:D9, B2:B9, "East", C2:C9, ">100") → East sales over 100

Practise it

• COUNTIFS, SUMIFS and MAXIFS
• Weeks, months and quarters in reports
• Challenge: quarterly sales summary