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
 
You must log in or register to reply here.

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

Find then highlight in yellow 6
Add to a "number as text" 10
Receiving valid Multicast address failed on mini port driver 0
Data sorting to a new sheet 7
Supressing a #VALUE! error returned? 3
Drop Down Menu - Data Selection Request 5
Access Running Balance in Access 1
Values of the last date 2

Back
Top