60 seconds Interactive Fix Excel Verified Office Standard

How to Sum with Multiple Conditions in Excel (SUMIFS Syntax Guide)

SUMIF only supports one condition. When you need to sum sales for a specific region AND a specific product, you must use SUMIFS.

Live browser simulator

Solve it right now

No login or Excel install required
# A B C D E
1 Region Status Amount
2 North Approved 500
3 North Pending 300
4 South Approved 400
5 North Approved 700
6
7 North Approved Total: 0 Fixed
Want to test your skills across 100+ workplace scenarios?

Deskademy simulates real office software with instant grading, hints, and certified CV credentials.

Start free training academy

Step-by-step instructions

1

Start with the Sum Range

Unlike SUMIF, SUMIFS begins with the numbers you want to add: =SUMIFS(sum_range, ...).

2

Add First Criteria Pair

Add the first range and condition: =SUMIFS(C2:C10, A2:A10, "North", ...).

3

Add Second Criteria Pair

Add the second range and condition: =SUMIFS(C2:C10, A2:A10, "North", B2:B10, "Approved").

500+ repeated drills

Master Excel in the Deskademy Gym

Drill 10+ repeated variations on this exact topic until it becomes second nature for your next job interview.

Open Excel Practice Gym

Deskademy Assistant

Thinking…