Sumif across workbook tabs

G

Guest

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top