Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
summarise totals from many worksheets into one final worksheet
I need to add totals from many worksheets onto one final Summary worksheet.
the formula I create is too long for Excel. is there a way to shorten the formula eg using the SUM function + Shift or Control keys? I believe Lotus is able to do this. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy worksheet & maintain cell reference across worksheets | Excel Worksheet Functions | |||
Link Worksheet to other worksheets | Excel Worksheet Functions | |||
Keep Format After Merging Worksheets Using CopyFromWorksheet Macro | Excel Discussion (Misc queries) | |||
Transferring date from multiple worksheets to a "totals" worksheet. | Excel Discussion (Misc queries) | |||
HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) |