Using data from different worksheets

[teck91]

I am trying to make a summary sheet of data i have 4 weeks of data and then a summary sheet all i want the summary sheet to do is calculate as i enter each weeks data HELP!!! iv tried all the formula's i can find but cant make it work properly...

[canapone]

Hi,

I'd add Peter (row9 sheet WK 3) in order to work with identical layouts and try in B2 (sheet TOTAL)

=Sum('WK 1:WK 4'!B2)

To be copied down and right, adjusting the % formulae.

Hope it helps

Regards