If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Referrence a total in a cell on another worksheet
I have created a workbook to track all my bank deposits, automatic deposits,
and credit card receipts. Each worksheet has a cell that contains the total receipts from the deposit entry date. Can I referrence this cell on another worksheet that will total all worksheet totals to date? In other words, I would have a running deposit (income) total for the year on one worksheet. |
#2
|
|||
|
|||
Referrence a total in a cell on another worksheet
Modify to suit for your first and last ws.
=sum(sheet1:sheet10!a2) -- Don Guillett Microsoft MVP Excel SalesAid Software "AndreaV" wrote in message ... I have created a workbook to track all my bank deposits, automatic deposits, and credit card receipts. Each worksheet has a cell that contains the total receipts from the deposit entry date. Can I referrence this cell on another worksheet that will total all worksheet totals to date? In other words, I would have a running deposit (income) total for the year on one worksheet. |
#3
|
|||
|
|||
Referrence a total in a cell on another worksheet
Thank you for the response. I do understand your response except for one
thing: The sheets referrenced are named on the tab, correct? So in my case, if the tab says SEPT 27 09, would your formula read: -sum(Jan 1 09:SEPT 27 09!H3)? Also, could I create a spreadsheet with the worksheet date and the sum for that worksheet referrenced, so I could sort and total by month/quarter/or year? Of course, in the above example, I wouldn't want to have to name each worksheet. "Don Guillett" wrote: Modify to suit for your first and last ws. =sum(sheet1:sheet10!a2) -- Don Guillett Microsoft MVP Excel SalesAid Software "AndreaV" wrote in message ... I have created a workbook to track all my bank deposits, automatic deposits, and credit card receipts. Each worksheet has a cell that contains the total receipts from the deposit entry date. Can I referrence this cell on another worksheet that will total all worksheet totals to date? In other words, I would have a running deposit (income) total for the year on one worksheet. |
#4
|
|||
|
|||
Referrence a total in a cell on another worksheet
Since the worksheet names have spaces in them you need to enclose them in
single quotes =SUM('Jan 1 09:SEPT 27 09'!H3) best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "AndreaV" wrote in message ... Thank you for the response. I do understand your response except for one thing: The sheets referrenced are named on the tab, correct? So in my case, if the tab says SEPT 27 09, would your formula read: -sum(Jan 1 09:SEPT 27 09!H3)? Also, could I create a spreadsheet with the worksheet date and the sum for that worksheet referrenced, so I could sort and total by month/quarter/or year? Of course, in the above example, I wouldn't want to have to name each worksheet. "Don Guillett" wrote: Modify to suit for your first and last ws. =sum(sheet1:sheet10!a2) -- Don Guillett Microsoft MVP Excel SalesAid Software "AndreaV" wrote in message ... I have created a workbook to track all my bank deposits, automatic deposits, and credit card receipts. Each worksheet has a cell that contains the total receipts from the deposit entry date. Can I referrence this cell on another worksheet that will total all worksheet totals to date? In other words, I would have a running deposit (income) total for the year on one worksheet. |
#5
|
|||
|
|||
Referrence a total in a cell on another worksheet
I like to create a couple of worksheets (First and Last) and put them to
the left and right of the worksheets with the data. Then my formula would look like: =sum('first:last'!a1) And I can add new sheets within this sandwich--or play what-if games by moving sheets inside or outside the sandwich. AndreaV wrote: I have created a workbook to track all my bank deposits, automatic deposits, and credit card receipts. Each worksheet has a cell that contains the total receipts from the deposit entry date. Can I referrence this cell on another worksheet that will total all worksheet totals to date? In other words, I would have a running deposit (income) total for the year on one worksheet. -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|