Hi Chris,

If I have understood your problem correctly

On the second work book write the formula at cell B2

=SUMIF(sheet1!A1:B10,B1,B1:B10)

B1 will have the name of the person.
This will sum-up the numbers for the person you are looking at the
first work book

I hope this helps you.


Thanks,

Shail
On Jan 31, 6:25 pm, Chris wrote:
I am trying to use vlookup to take a name from colum a on one work book and
look for numbers in another work book. I can do that fine. The problem is
that in the second work book there are many numbers for the same person and I
need these to be added together and a total of these numbers reported in
colum B in the first work book. Can anyone help