ExcelHeroThe SUMIFS function
Adds the cells that meet several conditions.
In German Excel: SUMMEWENNS
How to write it
=SUMIFS(sum_range, range1, criteria1, [range2, criteria2], …)- sum_range
- What to add (comes first!).
- range1, criteria1
- The first condition.
- range2, criteria2
- More conditions; all must be true.
💡 The order is different from SUMIF: the range to add comes first.
Try it
How much did Maya make with laptops? Use two conditions.
A
B
C
D
1
Region
Rep
Product
Amount
2
North
Maya
Laptop
1200
3
South
Leo
Phone
650
4
North
Leo
Phone
700
5
West
Maya
Tablet
480
6
North
Sam
Laptop
1100
7
South
Sam
Tablet
520
8
SUMIFS starts with the range to add, then pairs of range and condition.