Using =sum to add values of vlookup formula

L

loscherland

Table is as follows:

Name, Month 1, Month 2, Total
A 76 21 ?
B 72 23 ?
C 71 14 ?

Here's the formula used:

{To give value for Month 1} =VLOOKUP(B2,'Month 1'!$C$3:$F$28,4,FALSE)


{Value for Month 2} =VLOOKUP(B2,'Month 2'!$C$3:$F$28,4,FALSE)

{Total Month 1 plus Month 2 - returns value 0 each time
=SUM($D$2:$E$2
 
F

Frank Kabel

Hi
does changing your VLOOKUOP formulas in the following way help?:
=--VLOOKUP(B2,'Month 1'!$C$3:$F$28,4,FALSE)
and
=--VLOOKUP(B2,'Month 2'!$C$3:$F$28,4,FALSE)

If yes then your values in the table are probably stored as 'Text' values
and not as numeric values
 
D

dcronje

Everything looks OK to me but can you try the following:

=D2+E2

AND

=(VLOOKUP(B2,'Month 1'!$C$3:$F$28,4,FALSE))+(VLOOKUP(B2,'Mont
2'!$C$3:$F$28,4,FALSE))

Excel does "normally" add the values of the results of formulas!

The only way I can get excel to return a Zero is if I mistakenly creat
a circular reference (eg. I want to add C2+D2 and have the result in E
but I actually entered my formula as =sum(D2:E2))

Let us know the results of the above
 
Top