Formula for the total of the same cell on 16 Sheets

You can try...

=SUM(Sheet1:Sheet3!A2)

with Sheet1 the first and Sheet3 the last capturing everything inbetween.

Try,

=SUM(Sheet2:Sheet16!A2)

Not sure if it will work if you change the sheet names though?

Hi,

Thanks for taking an interest and making a suggestion.

I cannot do it with the formulas provided due to the sheet names

I can do it using this.....

=SUM(September09!N4+October09!N4+November09!N4+December09!N4+January10!N4+February10!N4+March10!N4+April10!N4+May10!N4+
June10!N4+July10!N4+August10!N4+September10!N4+October10!N4+November10!N4+December10!N4)

This is my real data.

It just seems a long winded way to go about it.
Any ideas on how this can be shortened?
I need to do another 3 formulas like this but with different cell references!!

Ak

Insert a sheet before the first sheet to be summed and rename it First. Leave it blank. Similarly add a Last sheet at the end. You can then use

=SUM(First:Last!A1)

for example.

K I S S

That is what somone told me years ago.

Your solution is perfect Peter,
thanks for coming to my rescue again.
I do insist on doing everything the hard way!

Thanks jrb and rs2k.

Ak