Google Spreadsheets add the previous months totals to current

xhmko Posts 1 Registration date Friday July 7, 2017 Status Member Last seen July 7, 2017 - Updated on Jul 7, 2017 at 05:44 AM

I have an accounting system set up on Google Spreadsheets with multiple tabs each with the monthly pays. But there are accumulative totals that need to add the previous months totals to the current months totals.

Previously I would duplicate the tab and rename it, and the formulas would carry over, for instance:

=sum('June 2017'!H35, H31)

would automatically become

=sum('July 2017'!H35, H31)

But this seems to have stoppd happening and I've had to manually change the formula.

Is there a way to make this an automatic function, so that, to follow the example, when I duplicate July's tab (which referenced June's tab) it would automatically change that reference to July?

Kind regards,