Creating aWorkbook that can average the data from all sheets

mrdanlambert

New Member
Joined
Aug 9, 2010
Messages
2
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-com:eek:ffice:eek:ffice" /><o:p></o:p>
<o:p></o:p>
Dan<o:p></o:p>
<o:p> </o:p>
 

Some videos you may like

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

Dannyh1

Well-known Member
Joined
Nov 18, 2009
Messages
1,144
Hi - to the 1st part, are all your answers in the same cell.

If so, try

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

mrdanlambert

New Member
Joined
Aug 9, 2010
Messages
2
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,110
Messages
5,599,773
Members
414,336
Latest member
Nicolas2465

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top