Running totals across multiple sheets

[jgwilkin]

Hello,

I'm struggling with the formulas across multiple sheets.

I'm presently trying to run about 10 worksheets on 1 excel save.

I need to be able to keep running totals across these sheets.

So for example, I need the total of Sheet 1 C47 + Sheet 2 C47

I then need the total of Sheet 1 C47 + Sheet 2 C47 + Sheet 3 C47

Then Sheet 1 C47 + Sheet 2 C47 + Sheet 3 C47 + Sheet 4 C47

etc etc...

However whenever I input formulas for this it reverts all the formulas on the other sheets.

For example - with my totals for C47 on sheet 1 in place, I will then input the formulas on sheet 2 get my totals for Sheet 1 C47 and Sheet 2 C47 - but for some reason it is then changing the formula on sheet 1 so that this also has the same formula for sheet 2. Which is not what I want.

Can anyone help with this? Please do let me know if I've not made complete sense.

Thanks very much in advance.

Josh