Counting etc over multiplesheets

  • Thread starter Thread starter hans
  • Start date Start date
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
 
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
 
Back
Top