Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
counting function but not double counting duplicates | Excel Worksheet Functions | |||
Counting | Excel Worksheet Functions | |||
Calculating values from multiplesheets with multiple criteria | Excel Worksheet Functions | |||
Counting rows, then counting values. | Excel Discussion (Misc queries) | |||
Counting names in a column but counting duplicate names once | Excel Discussion (Misc queries) |