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

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.