It is clear this is allowed and works:
=SUM(Sheet1:Sheet5!A1)
As the formula suggests the cell A1 in each sheet from Sheet1 through Sheet5
is summed.
This does not seem to work:
=SUM(Sheet1:Sheet5!Name_Ref1)
Where Name_Ref1 is a name of a cell defined in each worksheet.
More broadly I want to sum a given cell accross worksheets but that cell is
not be in the same position within each workseet.
Any ideas/comments...? Thanks
ShaunL