Formula not dragging?

[Ian Betteridge]

Excel 2007

Evening,
I've entered a formula in a cell then dragged down to calculate other rows. This calculated all the current data but only entered it as number format and didn't show the formula for future calculations..
Any ideas where I'm going wrong?

 

[Ian Betteridge]

Don't know if this will help, the formula I used was ............
=SUM((VLOOKUP($A3,Totals!$A$6:$Y$62,2,FALSE)+(VLOOKUP($A$3,Totals!$A$6:$Y$62,3,FALSE))))

Is the error in here or my settings?

 

[dave3009]

Have you tried

=VLOOKUP($A3,Totals!$A$6:$Y$62,2,FALSE)+VLOOKUP($A3,Totals!$A$6:$Y$62,3,FALSE)

 

[Ian Betteridge]

Thank you Dave, that works a treat. Don't understand why the other doesn't but I have a result with your suggestion.

 

[T. Valko]

Don't know if this will help, the formula I used was ............
=SUM((VLOOKUP($A3,Totals!$A$6:$Y$62,2,FALSE)+(VLOOKUP($A$3,Totals!$A$6:$Y$62,3,FALSE))))

Is the error in here or my settings?

Not sure what you're asking but you can reduce that formula to:

=SUMPRODUCT((Totals!$A$6:$A$62=$A3)*Totals!$B$6:$C$62)