Need help pulling percentages from all work pages

L

lumbergirl

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.
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I NEED SOME SERIOUS HELP =) 3
Help with percentages 1
need some basic help 4
Please help with SUM formula dependent on results of other cells 2
Problem with changing formula linked to another worksheet 9
Pulling Data from External Worksheets 4
Need a little help on this formula 2
Problem with =sum(offset(cell reference,w,x,y,z). I want cell reference to be variable 2

Top