| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking Totals Across Multiple Worksheets
I am trying to sum the totals (in accounting number format) across multiple
worksheets onto a single worksheet. I have tried manually creating the necessary formula (='ex1'!c19+'ex2'!c19+'ex3'!c19+....), and also copying th formula from a previous worksheet. No matter how I do this, the formula stays visible and does not calculate or become anything more than text. Is there any other way to sum across multiple pages? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I want to link totals on multiple worksheets into one total | Excel Worksheet Functions | |||
| Total multiple worksheets into totals worksheet | Excel Worksheet Functions | |||
| Adding up multiple worksheets by name and totals | Excel Worksheet Functions | |||
| linking multiple columns onto multiple worksheets | Excel Discussion (Misc queries) | |||
| Transferring date from multiple worksheets to a "totals" worksheet. | Excel Discussion (Misc queries) | |||
Threaded Mode
