 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / March 2008Average 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 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. >I am trying to average cells in multiple worksheets. > Let's say that in: [quoted text clipped - 6 lines] > > Thank you, 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 > if you want the average in the 5th sheet, > [quoted text clipped - 15 lines] > > > > Thank you, Karen Easier way is =AVERAGE(Sheet1!A1,Sheet2!A1,Sheet3!A1,Sheet4!A1) > 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 [quoted text clipped - 22 lines] >> > >> > Thank you, Karen Thank you VERY much! > Easier way is > [quoted text clipped - 26 lines] > >> > > >> > Thank you, Karen Easier to understand: =(Sheet1!A1+Sheet2!A1+Sheet3!A1+Sheet4!A1)/4  SignatureGary''s Student - gsnu200774 > 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? [quoted text clipped - 20 lines] > > > > > > Thank you, Karen Thank you VERY much! > Easier to understand: > [quoted text clipped - 24 lines] > > > > > > > > Thank you, Karen Thank you VERY much! > Easier to understand: > [quoted text clipped - 24 lines] > > > > > > > > Thank you, Karen 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 > 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? [quoted text clipped - 22 lines] > > - Show quoted text - Thank you VERY much! > Karen, > [quoted text clipped - 32 lines] > > > > - Show quoted text - =AVERAGE(Sheet1:Sheet4!A1) > I am trying to average cells in multiple worksheets. > Let's say that in: [quoted text clipped - 6 lines] > > Thank you, Karen |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.