ConditionsAdd with a condition: SUMIF
SUMIF adds only the rows that match: =SUMIF(where to look, what to look for, what to add).
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
9