PDA

View Full Version : excel newbie - averaging mulitple worksheets



18-07-2001, 10:20 AM
I have an application that produces multiple worksheets - each identical in format with a time column and several columns of results. I would like to be able to get an average of the results without the cutting and pasting. Can it be done?
Many thanks.

18-07-2001, 12:05 PM
If you want to access cells on different sheets when writing formula, you just prefix the cell with 'Sheetname'!...
So for example if you had two sheets, sheet1 and sheet2 and you wanted the average of cells A1 on each sheet your formula would be:
=( 'sheet1'!A1 + 'sheet2'!A1 ) / 2

18-07-2001, 02:42 PM
What Iain has said is correct except an easier way is to use the average function in excel, =average(Sheet1:Sheet2!A1:A4)