Sumif across workbook tabs

[tj]

I have a workbook of 10 tabs and need to be able to toggle whether or not to
include each tab in a summary presented in a separate tab. One idea was to
toggle each tab on or off and use the sumif function to sum the data if the
tab is toggled on (where 1 = on).

My formula is: =SUMIF('Sheet1:Sheet10'!E6,1,'Sheet1:Sheet10'!F6).

The result is a value error. Any suggestions?

 

[Biff]

Are your sheet names really Sheet1, Sheet2, Sheet3 etc ?

Biff

 

[Roger Govier]

Hi

You could achieve this a different way.
Create 2 new sheets called First and Last and drag these to positions
where they "sandwich" the set of sheet you wish to sum, but not your
Summary sheet.
On your Summary sheet, use the formula =SUM(First:Last!A1) etc. to
calculate the various totals required.
Now, dragging any individual sheet to a position outside of the sandwich
will exclude it from the summation.