ExcelBanter - AVERAGE Formula Help

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - AVERAGE Formula Help (https://www.excelbanter.com/excel-discussion-misc-queries/187469-average-formula-help.html)

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?

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?

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?