Cantrecallmyusername
Board Regular
- Joined
- May 24, 2021
- Messages
- 50
- Office Version
- 365
- Platform
- Windows
Hi there,
I have a sheet where I want to sum up hours for a person per month.
Tasks are entered on a row basis where the user enters the name in column C, hours per task for each month column H contains Jul, column H contains Aug, etc
On a separate sheet I want to sum all the hours for person A for each month.
I am not sure if this can be done in a vlookup, IF and SUM function as Vlookup will only return the 1st value.
I cant download the plugin to share excel file but here is an example of my dataset.
This is my raw data sheet
My desired outcome is to have on a separate sheet the person name listed in column A and the dates across row 1 and a formula to pull back the sum values from the dataset above
Name Jul-23 Aug-23 Sep-23 Oct-23 Nov-23 Dec-23
Person A 56 57 27 27 27 27
Person B 47 47 0 0 0 0
I hope this makes sense and thank you in advance for your help.
I have a sheet where I want to sum up hours for a person per month.
Tasks are entered on a row basis where the user enters the name in column C, hours per task for each month column H contains Jul, column H contains Aug, etc
On a separate sheet I want to sum all the hours for person A for each month.
I am not sure if this can be done in a vlookup, IF and SUM function as Vlookup will only return the 1st value.
I cant download the plugin to share excel file but here is an example of my dataset.
This is my raw data sheet
Name | Target Date | Jul-23 | Aug-23 | Sep-23 | Oct-23 | Nov-23 | Dec-23 | |||
Person A | 12 | 12 | 12 | 12 | 12 | 12 | ||||
Person A | 4 | 0 | 1 | 1 | 1 | 1 | ||||
Person A | 14 | 14 | 14 | 14 | 14 | 14 | ||||
Person A | 26 | 31 | 0 | 0 | 0 | 0 | ||||
Person B | 7 | 7 | 0 | 0 | 0 | 0 | ||||
Person B | 40 | 40 | 0 | 0 | 0 | 0 |
My desired outcome is to have on a separate sheet the person name listed in column A and the dates across row 1 and a formula to pull back the sum values from the dataset above
Name Jul-23 Aug-23 Sep-23 Oct-23 Nov-23 Dec-23
Person A 56 57 27 27 27 27
Person B 47 47 0 0 0 0
I hope this makes sense and thank you in advance for your help.