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?
|