| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum Wrong total but add each cell gives the correct total | Excel Worksheet Functions | |||
| How to get Total of Coloured Cell in a Colum and Worksheet | Excel Discussion (Misc queries) | |||
| total two cells from one worksheet to one cell in another workshee | Excel Discussion (Misc queries) | |||
| When using SUMIF won't worj with crieria = cell referrence | Excel Worksheet Functions | |||
| Is there a way to transfer a style by cell referrence in a formula | Excel Discussion (Misc queries) | |||
Threaded Mode
