Assume the first data sheet is called "First" and last is called "Last",
then in the Summary sheet for averages use

=AVERAGE(First:Last!A1)

and in the summary sheet for median

=MEDIAN(First:Last!A1)

note that non of the summary sheet should be included in the First:Last

then copy down to get the values for A2, A3 and so on



--
Regards,

Peo Sjoblom

Portland, Oregon




"George Reis"
wrote in message
...

I have several worksheets of the exact same size that only contains
numerical data. I'd like to create two new worksheets - one that shows
the median value of each cell, and one that shows the mean value of
each cell. That is, these will make the calculation for cell A1 from
each worksheet, then for cell A2 for each, then A3 ...

I'm completely clueless, so if anyone can help, I would appreciate baby
steps in the reply.

TIA,

George


--
George Reis
------------------------------------------------------------------------
George Reis's Profile:
http://www.excelforum.com/member.php...o&userid=30996
View this thread: http://www.excelforum.com/showthread...hreadid=506631