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 so much for your quick response. Your suggestion solved my problem!
 
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...
 
You must log in or register to reply here.

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

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

Back
Top