0 of 46 lessons complete.
Module 6: Conditional Math · Lesson 35 of 46
SUMIFS
Add values that meet multiple conditions.
Step 1 of 20%
SUMIFS handles multiple conditions. The sum range goes first, then pairs of (range, condition). In F1, total the cost of Steel bought from Acme.
Target: F1
A1
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Material | Supplier | Cost ($) | Steel from Acme | |||
| 2 | Steel | Acme | 1200 | Steel from Beta | |||
| 3 | Steel | Beta | 1500 | ||||
| 4 | Aluminum | Acme | 900 | ||||
| 5 | Steel | Acme | 800 | ||||
| 6 | Copper | Beta | 2100 | ||||
| 7 | Aluminum | Beta | 700 | ||||
| 8 | Steel | Beta | 600 | ||||
| 9 | |||||||
| 10 | |||||||
| 11 | |||||||
| 12 | |||||||
| 13 | |||||||
| 14 | |||||||
| 15 | |||||||
| 16 | |||||||
| 17 | |||||||
| 18 | |||||||
| 19 | |||||||
| 20 | |||||||
| 21 | Steel from Beta | ||||||
| 22 |
Arrow keys move · drag or shift-click to select a range · Ctrl/Cmd+D fill down · Ctrl/Cmd+R fill right · Alt+= AutoSum · F4 toggles $