View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
WAR WAR is offline
external usenet poster
 
Posts: 9
Default 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?