SUM of VLOOKUP Values

W

WAR

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

Peo Sjoblom

Probably text, try

=SUMPRODUCT(--(B2:B50))

you might be better off making sure your numbers are not text
 
W

WAR

Thanks for the quick reply. That did the trick!

Peo Sjoblom said:
Probably text, try

=SUMPRODUCT(--(B2:B50))

you might be better off making sure your numbers are not text
Click to expand...
 
Top