Looking at the below example, I'd like to be able to get the total hours of the individuals in column H by pulling their hours from Column E. Notice if there is more than one instance of someone's name, it only sums the first result. How might I be able to get the sum of a person's hours assuming their name appears multiple times in column D?
Thanks,
Thanks,
Line Productivity.xlsx | ||||||||
---|---|---|---|---|---|---|---|---|
D | E | F | G | H | I | |||
3 | Names | Hours | Name | Total Hours | ||||
4 | Bob | 5 | Bob | 5 | ||||
5 | Sue | 8 | Sue | 8 | ||||
6 | Billy | 5 | Billy | 5 | ||||
7 | Joe | 4 | Joe | 4 | ||||
8 | Matt | 8 | Matt | 8 | ||||
9 | Steve | 6 | Steve | 6 | ||||
10 | Mary | 7 | Mary | 7 | ||||
11 | Bob | 4 | ||||||
12 | Joe | 5 | ||||||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
I4:I10 | I4 | =INDEX(E:E,MATCH(H4,D:D,0)) |