Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formulas
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
formulas
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. "Jimbo" wrote: 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
formulas
Thank you so much for your help. =o) Have a nice day!
"JLatham" wrote: 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. "Jimbo" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sudden "0" output on Sumproduct formulas | Excel Discussion (Misc queries) | |||
how can i get formulas in excel to copy and paste? | Excel Worksheet Functions | |||
How to make Excel run limited number of formulas on a given worksh | Excel Discussion (Misc queries) | |||
Way to make Excel only run certain formulas on a worksheet? | Excel Discussion (Misc queries) | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |