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))
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.
You need to use Sumifs
=sumifs(E:E,D:D,H2)
 
Upvote 0
You're welcome & thanks for the feedback.
 
Upvote 0

Forum statistics

Threads
1,224,820
Messages
6,181,159
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top