Sum Across sheets

[LoftySuth]

I have a series of 12 sheets each named as a month
I wish to find the cumulative value of a cell in each month

So the January sheet would have a value .Range("AP9").Value
the February Sheet would have a value January!AP9 + February!AP9
March January!Ap9 + February!AP9 + March!AP9 and so on

I triedto achieve this with the following code

Please Login or Register  to view this content.

But this does nor work, the initial = sign causes an error, but without the sign all I have is a string not a formula
I need some help please
LoftySuth

[Jakobshavn]

Check this out...........in each sheet, cell AP9 contains the monthly amount and cell B10 contains the accumulative YTD amount:

Please Login or Register  to view this content.

Note that the January formula is unlike the other 11 formulas.

[FDibbins]

Unless you reallywant to use a macro for this, a relatively simple =SUM() will give you the results you need...
=SUM('Jan:Dec'!A1)

Adjust sheet names as needed

[mehmetcik]

I was also working on this.

combining my effort with Jakobshavn's:-

Please Login or Register  to view this content.

[mehmetcik]

it occurs to me that you might want to sort the sheets first.

Please Login or Register  to view this content.

[mehmetcik]

Alternatively you could use the Month Names instead of assuming that the sheets are sequential.

This is probably the most robust solution.

Please Login or Register  to view this content.

[LoftySuth]

Thank you all for your ideas. The key revelation to me was Sheets.Range.Formula. I don't really want to use a cumulative Cell (B10) but I think I will be able to write an accumulating string as in my original post (SFormula = SFormula &.....). Once again many thanks for all your contributions my jaw dropped when I opened up the Forum!