G
Guest
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!
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!