Help with formula using page names in averages

[HomrSmsm1]

I have a file that I want to enter 13 weeks of data for 100 rows and 5 columns. On the 14th page, I set up 2 list boxes with the first 13 page names as options. I want to be able to pick 2 page names from those boxes and use those in a claculation that will average data in a specific cell from choice page 1 to choice page 2. Is this possible?

 

[white6174]

yes it is
let me work on it for a while

I think it would be best to Define your ranges with a name (Named Range)

If you like you can email me your workbook or I could put together an example workbook

white6174@earthlink.net

steve w