Sumif across workbook tabs
 

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?

Sumif across workbook tabs
 

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?

Sumif across workbook tabs
 

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.

--
Regards

Roger Govier


"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?