ihaveanexcelquestion
New Member
- Joined
- Aug 29, 2022
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
In a project budget, I have an activity start date, end date, and a series of names associated. The data associated with each name is the number of hours they are budgeted for a particular task. I have a calculated field for each name showing the budgeted amount of time each day to spend on an activity.
I have a separate table where in Column A it is every date in the range listed (from minimum start date to maximum end date). In Row 1 I also have all the names mentioned above.
I would like to sum the total budgeted hours for each name across all activities. I'm having trouble with the sum formula that will return this value.
Activity | Start date | End date | Name 1 | Name 2 | Name etc. | Name 1 Calc Field - Hours per day | Name 2 Calc Field - Hours per day | ||||
Activity A | 1/1/2022 | 1/15/2022 | 5 | =5 / (End Date - Start Date) | |||||||
Activity B | 1/10/2022 | 2/4/2022 | 10 | 5 |
| =5 / (End Date - Start Date) |
I have a separate table where in Column A it is every date in the range listed (from minimum start date to maximum end date). In Row 1 I also have all the names mentioned above.
Date | Name 1 | Name 2 | Name etc. |
1/1/2022 | Need formula here that sums budgeted hours for Name 1 across all activities for this date | ||
1/2/2022 | |||
Etc. |
I would like to sum the total budgeted hours for each name across all activities. I'm having trouble with the sum formula that will return this value.