Sum values based on multiple conditions

To sum values based on multiple conditions in Excel, use the SUMIFS function.

✅ Syntax of SUMIFS

=SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)

• sum_range – the cells you want to sum.
• criteria_range1 – the first range to apply a condition to.
• criteria1 – the condition for the first range.
• You can add more criteria_range/criteria pairs as needed.

📌 Example Scenario

🔍 Goal: Sum sales where Product is “Apple” and Region is “North”

=SUMIFS(C2:C5, A2:A5, "Apple", B2:B5, "North")

✅ This returns 100 + 130 = 230.

🧠 Tip: Use cell references instead of hardcoded values

=SUMIFS(C2:C5, A2:A5, F1, B2:B5, F2)

Where F1 = Apple and F2 = North.

💡 You can also use operators:

=SUMIFS(C2:C100, B2:B100, ">100", A2:A100, "Orange")

This sums values where:

• Product = Orange
• Sales > 100