software

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: www.excelforum.com/member.php...oamp;userid=30996
View this thread: www.excelforum.com/showthread...hreadid=506631Assume the first data sheet is called quot;Firstquot; and last is called quot;Lastquot;,
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

quot;George Reisquot; gt;
wrote in message
...
gt;
gt; I have several worksheets of the exact same size that only contains
gt; numerical data. I'd like to create two new worksheets - one that shows
gt; the median value of each cell, and one that shows the mean value of
gt; each cell. That is, these will make the calculation for cell A1 from
gt; each worksheet, then for cell A2 for each, then A3 ...
gt;
gt; I'm completely clueless, so if anyone can help, I would appreciate baby
gt; steps in the reply.
gt;
gt; TIA,
gt;
gt; George
gt;
gt;
gt; --
gt; George Reis
gt; ------------------------------------------------------------------------
gt; George Reis's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30996
gt; View this thread: www.excelforum.com/showthread...hreadid=506631
gt;Enter the following formulas in a cell and copy down:

=MEDIAN('Sheet1:Sheet5'!A1)

and

=AVERAGE('Sheet1:Sheet5'!A1)

Change the sheet references accordingly.

Hope this helps!

In article gt;,
George Reis gt;
wrote:

gt; I have several worksheets of the exact same size that only contains
gt; numerical data. I'd like to create two new worksheets - one that shows
gt; the median value of each cell, and one that shows the mean value of
gt; each cell. That is, these will make the calculation for cell A1 from
gt; each worksheet, then for cell A2 for each, then A3 ...
gt;
gt; I'm completely clueless, so if anyone can help, I would appreciate baby
gt; steps in the reply.
gt;
gt; TIA,
gt;
gt; George


Thanks for the great help so far. I did a small test, and it's working.
But, for my real data, I think I need a little more help.

My data will come from several separate files, which I think I can just
copy and paste to make them separate sheets in a workbook (right? - or
can I work with them as separate files?). These will be huge -
thousands of cells in each. Will I have to manually write the formula
for each and every cell? Since each cell contains a reference to the
cell number, this seems likely to be the case, but I'm hoping that
there is a work-around. Also, I will eventually want to run this
formula on differents sets of data that would be different sizes, so if
there is any way to autogenerate this, I'd love to give it a try.

Thanks again for the formulas. I feel like I'm well on my way!George--
George Reis
------------------------------------------------------------------------
George Reis's Profile: www.excelforum.com/member.php...oamp;userid=30996
View this thread: www.excelforum.com/showthread...hreadid=506631I don't know if my situation is the same; but I am looking to get the
averages from cells C10:h10 in multiple worksheets (ie. Wk 1 - P, Wk 2 - P,
Wk 3 - P) etc. and put the average results in a cell on let's say Wk 4 - P.
I'm having a very difficult time writing out the formula on this one. I also
need the average to exclude zeros or null values.

quot;Domenicquot; wrote:

gt; Enter the following formulas in a cell and copy down:
gt;
gt; =MEDIAN('Sheet1:Sheet5'!A1)
gt;
gt; and
gt;
gt; =AVERAGE('Sheet1:Sheet5'!A1)
gt;
gt; Change the sheet references accordingly.
gt;
gt; Hope this helps!
gt;
gt; In article gt;,
gt; George Reis gt;
gt; wrote:
gt;
gt; gt; I have several worksheets of the exact same size that only contains
gt; gt; numerical data. I'd like to create two new worksheets - one that shows
gt; gt; the median value of each cell, and one that shows the mean value of
gt; gt; each cell. That is, these will make the calculation for cell A1 from
gt; gt; each worksheet, then for cell A2 for each, then A3 ...
gt; gt;
gt; gt; I'm completely clueless, so if anyone can help, I would appreciate baby
gt; gt; steps in the reply.
gt; gt;
gt; gt; TIA,
gt; gt;
gt; gt; George
gt;

I've replied here...

www.mrexcel.com/board2/viewto...327amp;highlight=

In article gt;,
quot;aka_krakurquot; gt; wrote:

gt; I don't know if my situation is the same; but I am looking to get the
gt; averages from cells C10:h10 in multiple worksheets (ie. Wk 1 - P, Wk 2 - P,
gt; Wk 3 - P) etc. and put the average results in a cell on let's say Wk 4 - P.
gt; I'm having a very difficult time writing out the formula on this one. I also
gt; need the average to exclude zeros or null values.
gt;
gt; quot;Domenicquot; wrote:
gt;
gt; gt; Enter the following formulas in a cell and copy down:
gt; gt;
gt; gt; =MEDIAN('Sheet1:Sheet5'!A1)
gt; gt;
gt; gt; and
gt; gt;
gt; gt; =AVERAGE('Sheet1:Sheet5'!A1)
gt; gt;
gt; gt; Change the sheet references accordingly.
gt; gt;
gt; gt; Hope this helps!
gt; gt;
gt; gt; In article gt;,
gt; gt; George Reis gt;
gt; gt; wrote:
gt; gt;
gt; gt; gt; I have several worksheets of the exact same size that only contains
gt; gt; gt; numerical data. I'd like to create two new worksheets - one that shows
gt; gt; gt; the median value of each cell, and one that shows the mean value of
gt; gt; gt; each cell. That is, these will make the calculation for cell A1 from
gt; gt; gt; each worksheet, then for cell A2 for each, then A3 ...
gt; gt; gt;
gt; gt; gt; I'm completely clueless, so if anyone can help, I would appreciate baby
gt; gt; gt; steps in the reply.
gt; gt; gt;
gt; gt; gt; TIA,
gt; gt; gt;
gt; gt; gt; George
gt; gt;