AVERAGE Formula Help

  • Thread starter Thread starter Steph
  • Start date Start date
S

Steph

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(Sheet1:Sheet63!A1)

will average all the sheets between 1 and 63
 
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?
 
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

Excel Highlighting duplicates 0
Excel Issue with "Average" showing in Status Bar 2
AVERAGE cells on another worksheet when the range is calculated 1
Excel Count If Formula Question 1
Need to merge worksheets - Excel 2003 0
Average Multiple Worksheets without blanks or zeros 2
Multiple criteria question 1
Conditional formatting using part of the cells contents 3

Back
Top