Why is your strategy not working, it sounds right?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"lumbergirl" wrote in message
...
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!
--
jennifer s