Counting etc over multiplesheets

H

hans

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
 
J

Jim

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
 
Top