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?