| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
AVERAGE Formula Help
I have a workbook with 63 worksheets in it. All of the worksheets are
formatted exactly the same. Is there a way to make a master sheet that will average all of the worksheets and be in the same format and layout? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
AVERAGE Formula Help
=AVERAGE(Sheet1:Sheet63!A1)
will average all the sheets between 1 and 63 -- Gary''s Student - gsnu200786 "Steph" wrote: I have a workbook with 63 worksheets in it. All of the worksheets are formatted exactly the same. Is there a way to make a master sheet that will average all of the worksheets and be in the same format and layout? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
AVERAGE Formula Help
Thanks, but it is not working. Maybe I am dense or something.
All of my info is in cell E5 across the sheets. The sheets are renamed as addresses. Should there be any ' in the formula? "Gary''s Student" wrote: =AVERAGE(Sheet1:Sheet63!A1) will average all the sheets between 1 and 63 -- Gary''s Student - gsnu200786 "Steph" wrote: I have a workbook with 63 worksheets in it. All of the worksheets are formatted exactly the same. Is there a way to make a master sheet that will average all of the worksheets and be in the same format and layout? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| A formula to AVERAGE IF but only average a set number of values | Excel Worksheet Functions | |||
| average-if-and formula | Excel Worksheet Functions | |||
| Average Formula | Excel Worksheet Functions | |||
| Average formula | Excel Discussion (Misc queries) | |||
| how does one convert text to a formula "average(A:A)" to =average( | Excel Worksheet Functions | |||
Hybrid Mode
