Just do a simple VLOOKUP(... in first sheet ...)+VLOOKUP(... in second sheet
....)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"AZExcelNewbie" wrote in message
...
Say I have three worksheets, two of them contain data which holds names.
I
need to sum up a certain persons name as they appear in the two different
worksheets in the third worksheet. How do I go about this? I've tried
using
a SUMPRODUCT with a VLOOKUP, but I can't seem to get it right, PLEASE
HELP!