Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup & summing
How can I do a vlookup to a certain field, then sum certain colums from the
table array that match the looked up field? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup & summing
there a couple fo ways to do this, pls provide your sample data and the
result you want. -- Pls provide your feedback by clicking the Yes button below if this post have help you. This will help others to search the archives for result better. Thank You cheers, francis "hcronrath" wrote: How can I do a vlookup to a certain field, then sum certain colums from the table array that match the looked up field? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup & summing
Not much to go on here. Maybe something like this:
=SUMPRODUCT(--(A19:A27=A19),B19:B27) Regards, Ryan--- -- RyGuy "xlmate" wrote: there a couple fo ways to do this, pls provide your sample data and the result you want. -- Pls provide your feedback by clicking the Yes button below if this post have help you. This will help others to search the archives for result better. Thank You cheers, francis "hcronrath" wrote: How can I do a vlookup to a certain field, then sum certain colums from the table array that match the looked up field? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup & summing
I think the OP means that there is a single match, but having found
the match he then wants to add some columns together from the corresponding row. Like you, I'm waiting for further details. Pete On Feb 11, 8:05*pm, ryguy7272 wrote: Not much to go on here. *Maybe something like this: =SUMPRODUCT(--(A19:A27=A19),B19:B27) Regards, Ryan--- -- RyGuy "xlmate" wrote: there a couple fo ways to do this, pls provide your sample data and the result you want. -- Pls provide your feedback by clicking the Yes button below if this post have help you. This will help others to search the archives for result better. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup & sum? or maybe summing dupes? | Excel Discussion (Misc queries) | |||
Using VLOOKUP for returning multiple values and summing them | Excel Worksheet Functions | |||
summing all results in a vlookup | Excel Worksheet Functions | |||
Summing vlookup cells | Excel Worksheet Functions | |||
Summing using VLOOKUP | Excel Discussion (Misc queries) |