stevensondas
New Member
- Joined
- Nov 26, 2021
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
Hi,
I am trying to develop a formula that allows me to sum the hours by resource in a spreadsheet. I have resources (people) in rows, and they appear in multiple tasks (rows) in the spreadsheet. They have hours spread across columns for the month they are forecasted to perform work in. I want to sum all the hours for a resource for each year (2021, and 2022). Any recommendations on a formula to do this is greatly appreciated. Thanks for taking a look!
I am trying to develop a formula that allows me to sum the hours by resource in a spreadsheet. I have resources (people) in rows, and they appear in multiple tasks (rows) in the spreadsheet. They have hours spread across columns for the month they are forecasted to perform work in. I want to sum all the hours for a resource for each year (2021, and 2022). Any recommendations on a formula to do this is greatly appreciated. Thanks for taking a look!
hours_example.xlsx | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | |||
1 | ||||||||||||
2 | 2021 | 2022 | ||||||||||
3 | Task | Resource | Oct | Nov | Dec | Jan | Feb | Mar | April | |||
4 | 1 | Mike | 120 | 120 | 120 | 80 | 80 | 80 | 80 | |||
5 | 2 | John | 80 | 80 | 80 | 80 | 80 | 80 | 80 | |||
6 | 3 | Tom | 160 | 160 | 160 | 160 | 160 | 160 | 160 | |||
7 | 4 | Chris | 40 | 40 | 40 | 40 | 40 | 40 | 40 | |||
8 | 5 | Mike | 40 | 40 | 40 | 40 | 40 | 40 | 40 | |||
9 | 6 | Wendy | 120 | 120 | 120 | 160 | 160 | 160 | 160 | |||
10 | 7 | John | 10 | 10 | 10 | 10 | 10 | 10 | 10 | |||
11 | ||||||||||||
12 | ||||||||||||
13 | 2021 | 2022 | ||||||||||
14 | Mike | |||||||||||
15 | John | |||||||||||
16 | Tom | |||||||||||
17 | Chris | |||||||||||
18 | Wendy | |||||||||||
Sheet1 |