Average Values / Multiple Worksheets
I 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.
"Domenic" wrote:
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 ,
George Reis
wrote:
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
|