Hi Esupply,

You can use the following formula in cell S24 on sheet 6WR-3780001:

=SUMIF(Sheet1!V:V,B24,Sheet1!AO:AO)

BUT..... your names in column V of "Sheet1" have spaces after them which won't allow for a match. You can either get rid of all the spaces (using a TRIM function for all cells in that column perhaps) or try this formula in S24:

=SUMIF(Sheet1!V:V,B24&"*",Sheet1!AO:AO)

Note that it will match similar names like "Paul Smith" and "Paul Smithson" or "David Toms" and "David Tomsak".