Sum Labor Hours by Trade
I need to calculate total hours worked where Trade is 'Electrician' and Shift is 'Night'.
=SUMIFS(C2:C9, A2:A9, "Electrician", B2:B9, "Night") How it works: The SUMIFS function allows you to sum values in a range that meet multiple criteria simultaneously. In this scenario, it sums the 'Hours Worked' (C2:C9) only for rows where the 'Trade' (A2:A9) is exactly 'Electrician' AND the 'Shift' (B2:B9) is exactly 'Night'. This provides a precise total for specific labor conditions, crucial for accurate project estimation and cost tracking.
Data Setup
| Trade | Shift | Hours Worked |
|---|---|---|
| Electrician | Day | 8 |
| Plumber | Night | 7 |
| Electrician | Night | 9 |
| Carpenter | Day | 10 |
| Electrician | Day | 6 |
| Plumber | Day | 8 |
| Electrician | Night | 7 |
| Carpenter | Night | 9 |
Step-by-Step Guide
Select the cell where you want the total hours to appear (e.g., D1).
Type `=SUMIFS(`. This initiates the SUMIFS function.
Select the range containing the values you want to sum, which is the 'Hours Worked' column: `C2:C9`.
Type `,` then select the first criteria range, which is the 'Trade' column: `A2:A9`.
Type `,` then enter the first criterion, which is the specific trade: `"Electrician"` (remember to use double quotes for text).
Type `,` then select the second criteria range, which is the 'Shift' column: `B2:B9`.
Type `,` then enter the second criterion, which is the specific shift: `"Night"`.
Close the parenthesis `)` and press Enter to get the result.