Sum Supply Costs by Project
I need to sum 'Cost' where Project is 'Sculpture' and Vendor is 'ArtSupplyCo'.
=SUMIFS(E2:E9, B2:B9, "Sculpture", D2:D9, "ArtSupplyCo") How it works: The SUMIFS function allows you to sum values in a range that meet multiple criteria. In this scenario, it sums the 'Cost' (E2:E9) only for rows where the 'Project' (B2:B9) is 'Sculpture' AND the 'Vendor' (D2:D9) is 'ArtSupplyCo'. Each criterion range is followed by its respective criterion, which must be enclosed in double quotes if it's text.
Data Setup
| Date | Project | Item | Vendor | Cost |
|---|---|---|---|---|
| 1/1/2023 | Sculpture | Clay | ArtSupplyCo | 50 |
| 1/5/2023 | Painting | Canvas | PaintStore | 30 |
| 1/10/2023 | Sculpture | Tools | HardwareInc | 75 |
| 1/15/2023 | Sculpture | Glaze | ArtSupplyCo | 25 |
| 1/20/2023 | Drawing | Pencils | ArtSupplyCo | 10 |
| 1/25/2023 | Sculpture | Wire | HardwareInc | 40 |
| 1/28/2023 | Painting | Brushes | PaintStore | 20 |
| 2/1/2022 | Sculpture | Armature | ArtSupplyCo | 60 |
Step-by-Step Guide
Open your Excel spreadsheet containing your supply cost data.
Identify the column you want to sum (Cost, which is column E in this example). This will be your 'sum_range'.
Identify the first criterion range (Project, column B) and the specific criterion ('Sculpture').
Identify the second criterion range (Vendor, column D) and the specific criterion ('ArtSupplyCo').
In an empty cell, type the SUMIFS formula: `=SUMIFS(E2:E9, B2:B9, "Sculpture", D2:D9, "ArtSupplyCo")`
Press Enter to see the total cost for 'Sculpture' projects purchased from 'ArtSupplyCo'.