Loading…
Loading…
SUMIFS adds the cells that meet several conditions.
=SUMIFS(sum_range, criteria_range1, criteria1, …)
| Argument | Required? | What it is |
|---|---|---|
| sum_range | Required | The cells to add up. If left out, the cells in range are added. |
| criteria_range1 | Required | The first range to test. Add more range/criteria pairs for more conditions. |
| criteria1, … | Required | The condition for criteria_range1, such as "North" or ">100". |
=SUMIFS(C2:C10,A2:A10,"Laptop",B2:B10,"South") adds sales that are Laptop and South.
From the lesson SUMIFS Function.
Type the formula yourself and get it graded instantly, no Excel needed.