SUM of VLOOKUP Values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Probably text, try

=SUMPRODUCT(--(B2:B50))

you might be better off making sure your numbers are not text
 
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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Why can't I sum several vlookups ?? 5
Sum Values from different column 1
Vlookup? 2
Problem with pasting value of a sum 3
Vlookup to reference offset 1
Using SUM & VLOOKUP together?? 1
displaying the correct value. 5
Dynamic col_index_num in VLOOKUP? 5

Back
Top