Calculate Total Rebar Usage per Zone
I need to sum the total weight of rebar used where the Zone is 'Foundation' and Type is 'Steel'. This helps in material tracking and budget management for specific structural elements.
=SUMIFS(D2:D9, B2:B9, "Foundation", C2:C9, "Steel") How it works: The SUMIFS function is used to sum cells that meet multiple criteria. In this scenario, it sums the 'Weight (kg)' only for rows where the 'Zone' column contains 'Foundation' AND the 'Type' column contains 'Steel'. This allows for precise material quantity take-offs based on specific project requirements.
Data Setup
| Project ID | Zone | Type | Weight (kg) | Cost ($) |
|---|---|---|---|---|
| P101 | Foundation | Steel | 500 | 1500 |
| P102 | Slab | Steel | 300 | 900 |
| P103 | Foundation | Concrete | 200 | 400 |
| P104 | Foundation | Steel | 750 | 2250 |
| P105 | Wall | Steel | 400 | 1200 |
| P106 | Slab | Concrete | 150 | 300 |
| P107 | Foundation | Steel | 600 | 1800 |
| P108 | Foundation | Steel | 800 | 2400 |
Step-by-Step Guide
Identify the range containing the values you want to sum. In this case, it's the 'Weight (kg)' column (D2:D9).
Identify the first criteria range, which is the 'Zone' column (B2:B9).
Specify the first criterion, which is 'Foundation'.
Identify the second criteria range, which is the 'Type' column (C2:C9).
Specify the second criterion, which is 'Steel'.
Combine these into the SUMIFS function: `=SUMIFS(sum_range, criteria_range1, criterion1, criteria_range2, criterion2)`.