Transporting sum from one sheet to another sheet in same workbook

B

Bourbon

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

How do I transport the sum (from one cell) of one sheet to another sheet in same workbook. i.e. Workbook called "Budget". Within the Budget Workbook there are several sheets entitled, e.g. "Housing"; "Personal"; "Pet Expenses"; "Medical Expenses" etc. I would like to transport each of the total expenses in a separate sheet within the same workbook called "Budget Summary" . The grand total of all expenses can then be made on the Summary Budget sheet.
 
J

JE McGimpsey

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

How do I transport the sum (from one cell) of one sheet to another sheet in
same workbook. i.e. Workbook called "Budget". Within the Budget Workbook
there are several sheets entitled, e.g. "Housing"; "Personal"; "Pet
Expenses"; "Medical Expenses" etc. I would like to transport each of the
total expenses in a separate sheet within the same workbook called "Budget
Summary" . The grand total of all expenses can then be made on the Summary
Budget sheet.

One way:

On a cell in sheet Summary Budget (where total cell in sheet "Housing"
is J10):

=Housing!J10
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top