Average Cells in Multiple Worksheets
 

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

Average Cells in Multiple Worksheets
 

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

Average Cells in Multiple Worksheets
 

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

Average Cells in Multiple Worksheets
 

Easier way is

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


"Karen" wrote in message
...
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

Average Cells in Multiple Worksheets
 

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

Average Cells in Multiple Worksheets
 

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

On Mar 19, 2:39*pm, 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- Hide quoted text -

- Show quoted text -

Average Cells in Multiple Worksheets
 

Thank you VERY much!

"Gaurav" wrote:

Easier way is

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


"Karen" wrote in message
...
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

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

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

Average Cells in Multiple Worksheets
 

Thank you VERY much!

"Pete_UK" wrote:

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

On Mar 19, 2:39 pm, 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- Hide quoted text -

- Show quoted text -

Average Cells in Multiple Worksheets
 

=AVERAGE(Sheet1:Sheet4!A1)


"Karen" wrote:

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