Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help pulling percentages from all work pages
I am trying desperately to pull GM percentages from all 10 work pages to get
an average GM for the Combined Sales page? I have tried every formula I can think of. Any suggestions? I tried typing an = sign in the cell I wanted the formula, clicking on each tab to assign the workpage and click on the cell location but the formula still came up wrong. I also tried with average and sum. -- jennifer s |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help pulling percentages from all work pages
Are the GM percentages in the same cell on each worksheet?
=AVERAGE(Sheet1:Sheet10!G23) should work. If not in same cell............. =AVERAGE(Sheet1!A1,Sheet2!A2,Sheet3!A3) will also work. Gord Dibben MS Excel MVP On Thu, 19 Jun 2008 08:18:03 -0700, lumbergirl wrote: I am trying desperately to pull GM percentages from all 10 work pages to get an average GM for the Combined Sales page? I have tried every formula I can think of. Any suggestions? I tried typing an = sign in the cell I wanted the formula, clicking on each tab to assign the workpage and click on the cell location but the formula still came up wrong. I also tried with average and sum. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I work on one page without seeing other pages | New Users to Excel | |||
Validation of Percentages Does Not Appear To Work | Excel Discussion (Misc queries) | |||
I can't get the percentages to work in a bar chart data label. | Charts and Charting in Excel | |||
Making changes in all pages in a work book | Excel Discussion (Misc queries) | |||
How do i work out percentages using excel? | Excel Discussion (Misc queries) |