Thank you so much to all the people who answered my question concerning creating a sum in excel. I now have a spreadsheet for my finances-gulp!
However, I now need to continue the claculations between 2 or more worksheets. The problem is that the letters are the same on all the worksheets so is it possible to do this or do I have to treat each page seperately and then sub-total individually? Thanks again for all your help.
2007-01-19 21:21:55 · 3 answers · asked by paula m 1 in Business & Finance ➔ Personal Finance
You can tab from page to page in your workbook using the tabs at the bottom.
You can begin a formula with an "=", then use your mouse to flip from page to page and click on the cells you want included in the formula.
Practice by just adding a cell from several pages, then edit the formula to see how Excell identified the addresses.
Instead of = A23 + C23
you'll get something like this:
= sheet1! A23 + sheet2! C23
2007-01-19 21:31:28 · answer #1 · answered by Anonymous · 1⤊ 0⤋
what the guy above said. basically if you do = in the cell then click where you want to go it will do it. it might even do it over different workbooks as well as worksheets
2007-01-20 07:27:53 · answer #2 · answered by alatoruk 5 · 0⤊ 0⤋
I don't know but if you find out, can you let me know. I have to do the same thing and am having trouble doing it. dana5169@yahoo.com
thanks
2007-01-20 05:31:02 · answer #3 · answered by dana5169 7 · 0⤊ 0⤋