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?