| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to easily put a sum of all pages
I have a multi-worksheet workbook and on the last sheet I want the sum of
certain cells from every worksheet. I.E. on the last sheet I may want in cell D3 the sum of cells D3 from all the other sheets. I have been doing for example =Worksheet1!D3+Worksheet2!D3 and so on, but that is cumbersome and if I insert a new worksheet I have to manually add it to the formula. Is there a quicker way? What if the cell in the summary page does not match the cells in the other worksheets, like I want the sum of all D3's in cell F5 of the summary? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Printing Hiden Pages | Excel Discussion (Misc queries) | |||
| Excel printing "additional" blank pages? | Excel Discussion (Misc queries) | |||
| How to print odd pages and even pages seperately in Excel. | Excel Discussion (Misc queries) | |||
| Count number of pages | Excel Worksheet Functions | |||
| How do I delete pages? | Excel Discussion (Misc queries) | |||
Threaded Mode
