| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 - |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 - |
|
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to make a macro to clear multiple cells from multiple worksheets? | Excel Worksheet Functions | |||
| Calculate Average Accross Multiple Worksheets | Excel Discussion (Misc queries) | |||
| 1 cell average across multiple worksheets | Excel Worksheet Functions | |||
| Average Values / Multiple Worksheets | Excel Worksheet Functions | |||
| adding certain cells in multiple worksheets in multiple workbooks | Excel Worksheet Functions | |||
Linear Mode
