Hi All,

I have a spreadsheet that has a summary sheet Profit & Loss statement for our business and then 10 product sheets P&L's, some of which role into this summary sheet, some do not.

At present, my formula is Sheet1!B1 + Sheet3!B3 + Sheet6!B3 etc etc.

** Note that product the sheets are not always next to each other so I cannot do =sum(sheet1!B3:sheet10!B3) for example**

So everytime i "add" an extra sheet to the workbook I have to enter a new formula and copy it down/across the sheet.

Is there a way in which I can have something like a CONSTANT that refers to pre-defined range of sheets so I can make any changes in one place.

The formula I am looking for is something like =sum(SummaryProductRange)B3

SummaryProductRange would refer to: Sheet1!B1 + Sheet3!B3 + Sheet6!B3 etc etc.

Do I need to create a VB function or just use something in XL?

Thanks
Gazzr