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.

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.

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.

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.

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