theYaniac
Board Regular
- Joined
- Jan 7, 2018
- Messages
- 64
- Office Version
- 365
- Platform
- Windows
I am trying to sum values in multiple columns based on a single criteria. For example I have a summary table that is looking at 4 columns for straight time hours and 4 columns for overtime hours. I would like to sum the values in the columns based on the position criteria. I have tried to use a sumifs formula to achieve but keep returning an error. The sumifs formula would need to sum values in columns D:K based on the criteria in column B. Column B would describe position(ex. Apprentice, Journeyman, Superintendent, etc).
<colgroup><col><col><col span="8"></colgroup><tbody>
</tbody>
CD Position | CD Job Number | CD ST Hours Job 1 | CD ST Hours Job 2 | CD ST Hours Job 3 | CD ST Hours Job 4 | CD OT Hours Job 1 | CD OT Hours Job 2 | CD OT Hours Job 3 | CD OT Hours Job 4 |
Superintendent | 20782 | 4.00 | 4.00 | 0.00 | 3.50 | ||||
Journeyman | 20782 | 4.00 | 4.00 | 0.00 | 3.50 | ||||
Journeyman | 20782 | 4.00 | 4.00 | 0.00 | 3.50 | ||||
Apprentice Level 7 & 8 | 20782 | 4.00 | 4.00 | 0.00 | 3.50 |
<colgroup><col><col><col span="8"></colgroup><tbody>
</tbody>