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

Biff

"tj" wrote in message
...
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?