L
lumbergirl
I have created a workbook to track sales, GM etc for each of our salesman in
each region. Each workbook contains a combined sales page and then 10
additional pages (one for each salesman). Ont he combined sheet I was able to
set up formulas to pull the dollar info from each cell on each page by using
the = sign and then clicking on each tab and then the cell. It worked great
to pull a grand total. I for the life of me cannot do the same for the GM
percentages. I need to get an average of these percentages from each page to
go on the combined sales page. Can anyone help? I have tried doing the same
formula as the dollar amount one but using average with failure.
Thanks so much!
each region. Each workbook contains a combined sales page and then 10
additional pages (one for each salesman). Ont he combined sheet I was able to
set up formulas to pull the dollar info from each cell on each page by using
the = sign and then clicking on each tab and then the cell. It worked great
to pull a grand total. I for the life of me cannot do the same for the GM
percentages. I need to get an average of these percentages from each page to
go on the combined sales page. Can anyone help? I have tried doing the same
formula as the dollar amount one but using average with failure.
Thanks so much!