Sheet summary totals

[Hugodey]

Hi All, my first posting.

I want to create a summary sheet in an annual tracker after each quarter summarising the totals from the previous 13 weeks. So the totals in the weekly sheets are B9,C9 etc through to I9. What formula do I need in order to get the running totals from these sheets to feed into the quarterly summary sheet?

[Deventus]

hi

you should just be able to link the sum to a worksheet
=sum('weekly sheets'!B9:C9)

Adi

[Hugodey]

Thanks Adi but when I enter the weeks sheet names between the single quote marks i.e. ('WK1'WK2'WK3'WK4') etc it comes back with a formula error. I haqve tried it without the single quote marks but the same error occurs. Any ideas what I am doing wrong? I have removed the C9 form your original suggestion as I only want the single column total from each of the subsequent sheets in the corresponding column on the summary sheet. So the formula looks as follows
=sum('WK1'WK2'WK3'WK4'WK5'WK6'WK7'WK8'WK9'WK10'WK11'WK12'WK13'!B9)

[Deventus]

Right, didnt realise you meant the same cell within each worksheets, if you change it tot the following it'll work, but all 13 sheets will need to be next to each other with no other worksheets inbetween,

=SUM(wk1:wk13!E19)

Adi

[Deventus]

Right, didnt realise you meant the same cell within each worksheets, if you change it tot the following it'll work, but all 13 sheets will need to be next to each other with no other worksheets inbetween,

=SUM(wk1:wk13!E19)

Adi