Average Cells in Multiple Worksheets

[Karen]

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

 

[Gaurav]

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]

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]

Easier way is

=AVERAGE(Sheet1!A1,Sheet2!A1,Sheet3!A1,Sheet4!A1)

 

[Gary''s Student]

Easier to understand:

=(Sheet1!A1+Sheet2!A1+Sheet3!A1+Sheet4!A1)/4

 

[Pete_UK]

Karen,

once you have set it up in the way that Gaurav advised, you can hide
the Start and End sheets so that your user would not know they are
there.

Hope this helps.

Pete

 

[Karen]

Thank you VERY much!

Easier way is

=AVERAGE(Sheet1!A1,Sheet2!A1,Sheet3!A1,Sheet4!A1)

 

[Karen]

Thank you VERY much!

Easier to understand:

=(Sheet1!A1+Sheet2!A1+Sheet3!A1+Sheet4!A1)/4

 

[Karen]

Thank you VERY much!

Easier to understand:

=(Sheet1!A1+Sheet2!A1+Sheet3!A1+Sheet4!A1)/4

 

[Karen]

Thank you VERY much!

Karen,

once you have set it up in the way that Gaurav advised, you can hide
the Start and End sheets so that your user would not know they are
there.

Hope this helps.

Pete

 

[Teethless mama]

=AVERAGE(Sheet1:Sheet4!A1)