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
|