formulas

[Guest]

I want to know if it is possible to create a formula that will add a total
from another open sheet in excel. My girlfriend and I have the same banking
acount but I keep track of our money seperately within the acount. I have a
setup now that works but I would like to change it by having my records on
one page then hers on another but showing the combined total of all funds on
both pages. Is this possible?

 

[Guest]

Yes, you can do this. Instead of just having a formula in a cell like
=A1+B1-C1
you might have something like
=A1+'YourSheet'!A1
That would take the contents of A1 on the sheet with the formula and add it
to the value in Cell A1 of a different sheet named 'YourSheet'

So you could set up some formulas on one sheet that might look like this:
on her sheet
=A1+'Jimbo'!A1
while at that same location over on your sheet it would read as
=A1+'GFSheet'!A1

Excel will do a lot of the work for you. Let's say you're setting up the
formula on your sheet to refer to some value on her (GFSheet) sheet. You
could start out by typing
=A1+
and then just click to select the GFSheet and click in the cell you want,
and then hit [Enter] (or continue typing more stuff as part of the formula)
and Excel will fill it all in for you as
=A1+'GFSheet'!A1

Good luck.

 

[Guest]

Thank you so much for your help. =o) Have a nice day!

Yes, you can do this. Instead of just having a formula in a cell like
=A1+B1-C1
you might have something like
=A1+'YourSheet'!A1
That would take the contents of A1 on the sheet with the formula and add it
to the value in Cell A1 of a different sheet named 'YourSheet'

So you could set up some formulas on one sheet that might look like this:
on her sheet
=A1+'Jimbo'!A1
while at that same location over on your sheet it would read as
=A1+'GFSheet'!A1

Excel will do a lot of the work for you. Let's say you're setting up the
formula on your sheet to refer to some value on her (GFSheet) sheet. You
could start out by typing
=A1+
and then just click to select the GFSheet and click in the cell you want,
and then hit [Enter] (or continue typing more stuff as part of the formula)
and Excel will fill it all in for you as
=A1+'GFSheet'!A1

Good luck.

I want to know if it is possible to create a formula that will add a total
from another open sheet in excel. My girlfriend and I have the same banking
acount but I keep track of our money seperately within the acount. I have a
setup now that works but I would like to change it by having my records on
one page then hers on another but showing the combined total of all funds on
both pages. Is this possible?