Summing lookup values
 

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

Summing lookup values
 

=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

Summing lookup values
 

<and display 1062.

I assume you mean 1602. Please be precise when asking assistance: we don't know your workbook!

Use SUMIF() instead
Look in HELP for assistance, post again in this same thread if you have difficulties.

--
Kind regards,

Niek Otten


"~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
|

Summing lookup values
 

Try something like this:

With the data list in cells A1:B10

C1: Ashish
C2: =SUMIF($A$1:$A$10,C1,$B$1:$B$10)


Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"~C" wrote:

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

Summing lookup values
 

C -- Here's an approach:

A B C D
1 Ash 1
2 Ash 2
3 Ash 3
4 Pon 4
5 Pon 5
6 Pon 6
7 Raj 7
8 Raj 8
9 Raj 9
10
11 Ash =sumif($A$2:$A$9,A11,$B$2:$B$9)
12 Pon
13 Raj

HTH

"~C" wrote:

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