| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUM of VLOOKUP Values
I have several rows of values which were obtained using VLOOKUP. When I
attempt to SUM these rows, I get 0.00 as a value. If I individually "+" the rows, I get the correct value. Any suggestions? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SUM of VLOOKUP Values
Probably text, try
=SUMPRODUCT(--(B2:B50)) you might be better off making sure your numbers are not text -- Regards, Peo Sjoblom "WAR" wrote in message ... I have several rows of values which were obtained using VLOOKUP. When I attempt to SUM these rows, I get 0.00 as a value. If I individually "+" the rows, I get the correct value. Any suggestions? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SUM of VLOOKUP Values
Thanks so much for your quick response. Your suggestion solved my problem!
"Peo Sjoblom" wrote: Probably text, try =SUMPRODUCT(--(B2:B50)) you might be better off making sure your numbers are not text -- Regards, Peo Sjoblom "WAR" wrote in message ... I have several rows of values which were obtained using VLOOKUP. When I attempt to SUM these rows, I get 0.00 as a value. If I individually "+" the rows, I get the correct value. Any suggestions? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SUM of VLOOKUP Values
Thanks for the quick reply. That did the trick!
"Peo Sjoblom" wrote: Probably text, try =SUMPRODUCT(--(B2:B50)) you might be better off making sure your numbers are not text -- Regards, Peo Sjoblom "WAR" wrote in message ... I have several rows of values which were obtained using VLOOKUP. When I attempt to SUM these rows, I get 0.00 as a value. If I individually "+" the rows, I get the correct value. Any suggestions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vlookup with 2 values | Excel Worksheet Functions | |||
| Vlookup and Values | Excel Worksheet Functions | |||
| Can you use 2 look up values in VLookup? | Excel Worksheet Functions | |||
| vlookup, multiple values, sum values into one cell?? | Excel Worksheet Functions | |||
| vlookup with 2 values | Excel Discussion (Misc queries) | |||
Hybrid Mode
