Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
summing all results in a vlookup
I need to sum all of the values in a vlookup formula. Currently the formula
only brings the value over for the first item that is found. It does not continue to search the table for additional values and sum all of the values together. Any help would be appreciated. -- Valerie |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
summing all results in a vlookup
=SUMIF(A2:A100,lookup_value,C2:C100)
adapt to fit -- Regards, Peo Sjoblom "Valerie" wrote in message ... I need to sum all of the values in a vlookup formula. Currently the formula only brings the value over for the first item that is found. It does not continue to search the table for additional values and sum all of the values together. Any help would be appreciated. -- Valerie |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
summing all results in a vlookup
Rather than VLOOKUP, take a look at the SUMIF function.
=SUMIF(range_to_search,match,range_to_sum) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting www.cpearson.com (email on the web site) "Valerie" wrote in message ... I need to sum all of the values in a vlookup formula. Currently the formula only brings the value over for the first item that is found. It does not continue to search the table for additional values and sum all of the values together. Any help would be appreciated. -- Valerie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup results in 0 | Excel Discussion (Misc queries) | |||
Vlookup with two results | Excel Discussion (Misc queries) | |||
Summing vlookup cells | Excel Worksheet Functions | |||
Summing using VLOOKUP | Excel Discussion (Misc queries) | |||
summing lookup results | Excel Discussion (Misc queries) |