Hi All,

In the attached spreadsheet I have various data dump tabs will call volumes from 3 different (fictitious) lines, I am looking to work out average call volumes across each day of the week over varying time frames.

each data sheet is named with the date the calls took place, I have a sheetnames tab that automatically lists the sheetnames as they're created, converts it to a date, checks if there's data entered and provides the day of the week that date happens to be.

In theory I would like the drop down box for number of weeks to power the range through which the sumifs formula would calculate.

i.e if 5 is selected the range would be the 5 weeks from the last sheetname (31102014 in this example) and then only the days and time ranges for this period would be "summed" in the call volumes tab.

this is a head scratch-er for me at the moment (been thinking about this for a few hours now and now solution yet.

any help would be greatly appreciated.

Example.xlsm