Counting etc over multiplesheets
 

I want to make a workbook containing a number of sheets
sheetnames ale 01, 02, 03 ,04 etc etc
I do not know what the last sheetname wil be!!!!
and i have a sheet called avarages

What i want is to have the average of cells 01!a1, 02!a1, 03!a1 etc etc on
sheet avarages!a1

I also want to know on how many of these sheets 01,02,03,04 etc a numer
between 1 and 5 is entered in A1

I know i can use =avarage('01:05'!a1) but i do not want to have to change
all formulas if a new sheet is added

Can someone please help.

Greetings Hans

Counting etc over multiplesheets
 

It all depends on where you insert your new sheets. Don't insert at the end of the range. To prevent this set up a DUMMY sheet at the end which does not affect your averages.

HTH,

Jim