Applying figures and sums of figures to relevent cells

[JakeMann]

Hello,

I've been doing a test on the attached.

On page 'test' I have a list of week numbers in column A and in column B I want to automatically add the relevent quantity from the table in E2:G7.

I've tried a SUMIF to get this to work but it's not having it (=SUMIF(E3:F7,A2,F3:F7). And a lookup seems to good either.

Is there a better way?

Thanks

[Pepe Le Mokko]

Perhaps amend your formula to

Please Login or Register  to view this content.

[Fotis1991]

You just need absolute reference in your formula.

=SUMIF($E$3:$F$7,A2,$F$3:$F$7)

[Fotis1991]

edit: Deleted

Dublicate post...Same again....

[JakeMann]

Thanks Pepe, that's worked perfectly.

[JakeMann]

Thanks guys, it's all working fine now.