SUMIF
SUMIF adds values that meet one condition.
Syntax
=SUMIF(range,criteria,[sum_range])
Example
|
Employee |
Region |
Sales |
|
Amit |
North |
50000 |
|
Neha |
South |
60000 |
|
Rahul |
North |
75000 |
|
Priya |
South |
40000 |
To calculate total North sales:
=SUMIF(B2:B5,”North”,C2:C5)
Result: ₹125,000
SUMIFS
SUMIFS adds values that meet multiple conditions.
Syntax
=SUMIFS(sum_range,criteria_range1,criteria1,criteria_range2,criteria2,…)
Example:
=SUMIFS(C2:C10,B2:B10,”North”,D2:D10,”Laptop”)
This calculates sales where:
- Region = North
- Product = Laptop
SUMIF vs SUMIFS
|
SUMIF |
SUMIFS |
|
One condition |
Multiple conditions |
|
Simple conditional total |
Advanced conditional total |