Setting up a running balance.

Copper Contributor

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?

2 Replies

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