Loading…
Loading…
SUMIFS adds numbers that meet several conditions at once. Note the order: the sum_range comes first, then pairs of criteria_range and criteria. Every condition must be true for a row to be added.
Syntax
SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], …)
Example: =SUMIFS(C2:C10,A2:A10,"Laptop",B2:B10,"South") adds sales that are Laptop and South.
Common mistakes
Read the lesson, then try it yourself in a live spreadsheet.