| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum a range of workbooks?
A user has 4 separate files with the 4th file being a summary file; Alloc1,
Alloc2, Alloc3 and Summary files. The Alloc files have numbers in the same corresponding cells she wants to add together to get the summary numbers. What she wants to do is use a formula to sum the range of workbooks such as =SUM(Alloc1!B8:Alloc3!B8). Can this be done somehow? I tried using named ranges in the Summary sheet to no avail. Maybe with script? Yes, I know you can use plus signs to add the 3 cells together, but this user is a bit "wants things her own way". TIA! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Issues referencing range between workbooks | Excel Discussion (Misc queries) | |||
| Copy a range from closed workbooks (ADO) | Excel Discussion (Misc queries) | |||
| copy range to multiple workbooks | Excel Discussion (Misc queries) | |||
| Select same range from large number of workbooks | Excel Worksheet Functions | |||
| Formula to Sum a definable range of workbooks | Excel Worksheet Functions | |||
Threaded Mode
