StephenM123
New Member
- Joined
- Apr 19, 2019
- Messages
- 8
Afternoon all,
Looking for some help/advice please... I hope this makes sense.
I have a holiday file which is set out in a similar manner as below and tracks the full year.
The actual file has around 400 employees in it but for the sake of this I've just classes a few as different job types.
The columns do not change and stay the same but I want my output to have an 8 week future view of hours booked.
I'm looking for a way to sum all holidays hours from the week per process in to seperate buckets. (I want to use a formula if possible and not a pivot)
I know I could do multiple sumifs for each column and add them together in the one but surely there is an easier way?
<tbody>
</tbody>
Example Output - This would give an 8 week view changing as the weeks tick by:
<tbody>
</tbody>
Any help would be brilliant or if you need more information I'll try give you as much as possible.
Thank you!
Looking for some help/advice please... I hope this makes sense.
I have a holiday file which is set out in a similar manner as below and tracks the full year.
The actual file has around 400 employees in it but for the sake of this I've just classes a few as different job types.
The columns do not change and stay the same but I want my output to have an 8 week future view of hours booked.
I'm looking for a way to sum all holidays hours from the week per process in to seperate buckets. (I want to use a formula if possible and not a pivot)
I know I could do multiple sumifs for each column and add them together in the one but surely there is an easier way?
Week Num | 40 | 40 | 40 | 40 | 40 | 41 | 41 | 41 | 41 | 41 | 41 | 41 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | |
Job | Date | 01-Oct | 02-Oct | 03-Oct | 04-Oct | 05-Oct | 06-Oct | 07-Oct | 08-Oct | 09-Oct | 10-Oct | 11-Oct | 12-Oct | 13-Oct | 14-Oct | 15-Oct | 16-Oct | 17-Oct | 18-Oct | 19-Oct |
Desk | Day | 10 | 10 | 10 | ||||||||||||||||
Desk | Day | 10 | ||||||||||||||||||
Desk | Day | 10 | 10 | 10 | 10 | 10 | 10 | 10 | ||||||||||||
Desk | Day | |||||||||||||||||||
Desk | Back | |||||||||||||||||||
Desk | Back | |||||||||||||||||||
Logistics | Day | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | |||||||||
Logistics | Day | |||||||||||||||||||
Logistics | Day | |||||||||||||||||||
Logistics | Day | 10 | 10 | 10 | 10 | 10 | 5 | 5 | ||||||||||||
Logistics | Back | 10 | 10 | |||||||||||||||||
Logistics | Back | 10 | 10 | |||||||||||||||||
Operation | Day | |||||||||||||||||||
Operation | Day | 10 | ||||||||||||||||||
Operation | Day | 10 | ||||||||||||||||||
Operation | Day | 10 | ||||||||||||||||||
Operation | Back | 10 | ||||||||||||||||||
Operation | Back | 10 | ||||||||||||||||||
Virtual | Day | 10 | ||||||||||||||||||
Virtual | Back | |||||||||||||||||||
Virtual | Back |
<tbody>
</tbody>
Example Output - This would give an 8 week view changing as the weeks tick by:
Job/Week | 40 | 41 | 42 |
Desk | 50 | 10 | 50 |
Logistics | 90 | 70 | 40 |
Operation | 50 | ||
Virtual | 10 |
<tbody>
</tbody>
Any help would be brilliant or if you need more information I'll try give you as much as possible.
Thank you!