Creating aWorkbook that can average the data from all sheets

[mrdanlambert]

I am looking to create a workbook. In this workbook each sheet would have formulas to average numbers, and each sheet is formatted the same. Next, I would like the 1st sheet in the workbook to average the data from the other sheets and display a summary report. Additionally, I would like to learn how to add a code to each sheet so the sheets could also be sorted by code. Help.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
Dan<o></o>
<o> </o>

 

[Dannyh1]

Hi - to the 1st part, are all your answers in the same cell.

If so, try

=AVERAGE('Sheet 1:Sheet 10'!A1)

 

[mrdanlambert]

Re: Creating workbook that can average the data from all sheets

1. There are a range of cells on each sheet. For example b4 - e4, b6-e6, on sheet 1, 2, and 3 that I would like to average on a cover sheet. However this is a good start thank you and I look forward to additional community input.