Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 | |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
summing lookup results | Excel Discussion (Misc queries) | |||
lookup mutliple values to return one value | Excel Worksheet Functions | |||
summing values appearing in col B when col A has been filtered | Excel Worksheet Functions | |||
how do I lookup multiple values | Excel Discussion (Misc queries) | |||
Using SumIF formulas with multiple lookup values | Excel Worksheet Functions |