ExcelHeroThe SUMIF function
Adds the cells that meet one condition.
In German Excel: SUMMEWENN
How to write it
=SUMIF(range, criteria, [sum_range])- range
- Where to check the condition.
- criteria
- What to look for, like "North" or ">600".
- sum_range
- Optional. What to add. Leave out to add range itself.
💡 Wildcards work: "*top" matches anything ending in “top”.
Try it
What did the North region sell in total?
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
Look in the Region column for "North", then add the Amount column.