Cell with many names converted to total hrly wage

Hello and thank you for taking the time to help. I have a spreadsheet I am putting together and will submit to my VP's on a quarterly basis. I have attached and example with fake names to better see what I am getting to. What I need is to look at the cell in "H" and depending on what names are in there, it will sum up the hourly wages by looking at the individual wages on the second tab. New lines will be added daily as my assistant managers will input each day. So for example, the total in I2 would be 74.08. I was trying to write a code that would split the names into columns and then look up that way, but I really just keep going in circles on this one, and am not great at code writing to begin with.

I hope this was not too confusing.

Thanks,

Charity

Oh my goodness that worked. I have been working on that for days! Thank you so very much!!

Hello again,

So I tried it on my spreadsheet again, and for some reason, it seems as if it is adding the rows to the row before perhaps. This is what totals come up, even if the names are the same in about 8 of the cells to calculate. I re-created it on my example sheet for your viewing. and if i add rows, do i need to run the macro each time?

Thanks again for helping!

If you do not want to run the code each time you can use a user defined function like

this formula in cell I2 =MVLookup(H2,'List of Hourly Wages'!$A$2:$B$10,2) then copy down, that's it !

But as a reminder, the VLOOKUP worksheet function works only if you remove this silly space in front of some of your List names …

PHP Code: 

Function MVLookup#(S$, Rg As Range, C%)
     Dim A$, V
         A = """," & Rg.Address(External:=True) & "," & C & ",FALSE),)"
    For Each V In Split(S, ", "):  MVLookup = MVLookup + Evaluate("IFERROR(VLOOKUP(""" & V & A):  Next
End Function 


Do you like it ? So thanks to click on bottom left star icon « ★ Add Reputation » !

Thank you once again. That is EXACTLY what i was looking for. I didn't even realize I had the space

Thanks for the rep' !

I find out why my code fails when I manually test the VLOOKUP worksheet function on your data …