I've been using a Sumif function to find a name in a range and return the value to the right of it. Now I am trying to look in that same range for multiple names and return all the values to the right of them and add them up.

I do not know if this can be done with this function:

=SUMIF('WORK SHEET'!$C$42:$BA$59,'Hourly Rates'!A2:A39,'WORK SHEET'!$D$42:$BB$59)