excluding sheets from SUM formula

hi,

i have been searching and i can't find a way to exclude a sheet from an SUM formula. i have about 70 sheets that i use in another sheet with multiple SUM formulas, SUM('Sheet1:Sheet70'D10)

now, i have to throw a couple sheets in between the 70 that i do not want added to the SUMs. i can't put these new sheets at the beginning or end of the 70 sheets, unfortunately.

1)is there a way to simply exclude those sheets from the SUM formula?

2) is there an easy way to copy/paste the sheet names into the formula (instead of using the method of sheet 1 to sheet 70), then just remove the sheets i want to exclude?

thanks...

Originally Posted by NBVC

One way that may be a simple enough solution would be to subtract the sum of the unwanted sheets...

e.g. =SUM('Sheet1:Sheet70'!D10)-SUM('Sheet5:Sheet6'!D10)


would subtract Sheet5!D10 to Sheet6!D10

ack...i forgot that i am using AVERAGE formulas as well. i apologize for not mentioning that.

i assume your solution would not work for AVERAGE formulas...

no, because i am averaging percentages, unfortunately.

so there's no easy way to exclude certain sheets in the formulas?