Need help with a Sumif() function

[pasqualebaldi]

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:

Please Login or Register  to view this content.

[Jonmo1]

Try putting SUMPRODUCT around it..

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

[pasqualebaldi]

Try putting SUMPRODUCT around it..

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

Thank you!

[Jonmo1]

You're welcome.