Forum Discussion
Setting up a running balance.
I have a main worksheet and I want to pull from other tabs to keep a running balance on the main tab, how do I do this?
hia,
you can reference cells on other worksheets by using the name of the sheet with an !
so if you wanted to add up cells A1 to A10 on Sheet 2, you could do so like this:
=SUM(Sheet2!A1:A10)
If you wanted to add up A1 on sheet 2, with B5 on Sheet 3 you could do that with something like =Sheet2!A1 + Sheet3!B5
- Great
