Hi there,

I analyse ticket sales data and want to be able to see, from historical sales-by-day data, the average % of total sales on any given number of days prior to the show. 

I’ve put the sales data into one workbook as different sheets, formatted identically. Say column I is the ‘days prior’ and column J is the % of total sales. E.g. I150 (value 130) corresponds to J150 (value 5.0%). 

On a summary page I want to see the avg % of total ticket sales (averaged from every sheet) for that specific ‘day prior’. 

Later I’ll want to see by year, by location, etc. but for now that’s where I’m stuck. 

Advice appreciated. 

​Hi there, I analyse ticket sales data and want to be able to see, from historical sales-by-day data, the average % of total sales on any given number of days prior to the show.  I’ve put the sales data into one workbook as different sheets, formatted identically. Say column I is the ‘days prior’ and column J is the % of total sales. E.g. I150 (value 130) corresponds to J150 (value 5.0%).  On a summary page I want to see the avg % of total ticket sales (averaged from every sheet) for that specific ‘day prior’.  Later I’ll want to see by year, by location, etc. but for now that’s where I’m stuck.  Advice appreciated.   Read More

​