Average Cells in Multiple Worksheets
Thank you VERY much!
"Gary''s Student" wrote:
Easier to understand:
=(Sheet1!A1+Sheet2!A1+Sheet3!A1+Sheet4!A1)/4
--
Gary''s Student - gsnu200774
"Karen" wrote:
WOW! This is amazing! I never knew this one. Although, the person I'm
setting it up for would get confused with this. Do you have an easier method?
I will make a mental note of this one though - Thanks!
Karen
"Gaurav" wrote:
if you want the average in the 5th sheet,
Create 2 dummy sheets named Start(Before Sheet1) and End(After Sheet4). In
the cell where you need the average write this formula.
=AVERAGE(Start:End!A1)
Format cell as %age and hide the dummy sheets.
"Karen" wrote in message
...
I am trying to average cells in multiple worksheets.
Let's say that in:
Sheet1 Cell A1 = 4.40%
Sheet2 Cell A1 = 2.65%
Sheet3 Cell A1 = 3.61%
Sheet4 Cell A1 = 1.59%
What would be the formula to average these percentages?
Thank you, Karen
|