=SUMIF(A:A,"Ashish",B:B)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"~C" wrote in message
...
I have a spreadsheet and I need to use a VLookup that then sums the
returned
values that repeat. Below is an example, where Ashish shows up 3 times in
my
lookup table and I want it to add together 834+534+234 and display 1062.
I
can do this manuall, but have no idea how to have this automated using a
Vlookup function.

Ashish Pongal Rajesh Sanjay
1602 434 634 1068
Ashish 834
Ashish 534
Ashish 234
Pongal 434
Rajesh 634
Sanjay 334
Sanjay 734