P
Paul
I have a collection of worksheets, each with the same format of report, and a
summary sheet which shows the name of each worksheet.
I want to create a selection sheet, where I can mark each of the required
sheets and have the selection sheet show the summed data.
I have tried :
=sumproduct(SheetA:SheetZ!C10,SheetA:SheetZ!$A$1), but it returns a #REF error
(A1 in each sheet holds a 1 if the sheet is required to be included.)
(C10, plus a number of other cells, holds the relevant data on each worksheet)
Any help would be appreciated
summary sheet which shows the name of each worksheet.
I want to create a selection sheet, where I can mark each of the required
sheets and have the selection sheet show the summed data.
I have tried :
=sumproduct(SheetA:SheetZ!C10,SheetA:SheetZ!$A$1), but it returns a #REF error
(A1 in each sheet holds a 1 if the sheet is required to be included.)
(C10, plus a number of other cells, holds the relevant data on each worksheet)
Any help would be appreciated