Using =sum to add values of vlookup formula

L

loscherland

Is it possible to add the values given by a vlookup formula?

Eg.

I've 2 colums - Month 1 & Month 2

The values for month 1 & Month 2 are taken using a vlookup formula - s
when u try & do an =sum to add month 1 & month 2, it give 0 as there i
no value in either column, just a formul
 
D

dcronje

It should give the sum.

Are you sure that the lookups are not returning zero?

Another thing is press F9 to calculate maybe your calculation is set t
manual.

Maybe post your formulas as there could an error with them
 

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

Vlookup 4
Using =sum to add values of vlookup formula 2
VLookUP formula help! 5
sum with multiple criteria 4
Adjusting formula for month in vlookup? 3
Using =sum to add values of vlookup formula 1
Average formula multiple worksheets 1
Xlookup that returns variable sum data 3

Top