Sum Index Match with multiple matches

mdshields

New Member
Joined
Jun 30, 2016
Messages
33
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,

Line Productivity.xlsx
DEFGHI
3NamesHoursNameTotal Hours
4Bob 5Bob 5
5Sue8Sue8
6Billy5Billy5
7Joe4Joe4
8Matt8Matt8
9Steve6Steve6
10Mary7Mary7
11Bob 4
12Joe5
Sheet1
Cell Formulas
RangeFormula
I4:I10I4=INDEX(E:E,MATCH(H4,D:D,0))
 

Some videos you may like

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
44,505
Office Version
365
Platform
Windows
You need to use Sumifs
=sumifs(E:E,D:D,H2)
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
44,505
Office Version
365
Platform
Windows
You're welcome & thanks for the feedback.
 

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,105,930
Messages
5,508,184
Members
408,669
Latest member
AgsikapAko

This Week's Hot Topics

Top