variable averageif

Hi Guys,

Im trying to setup a small workbook that will average data if it fits certain criteria.

I've attached the workbook here.

Sheet 1 contains the data.

sheet 2 contains the extracted data

There are two variables to consider.

Average (MONDAYS) in (June)
Average (Weekdays) in (September)
Average (Weekends) in (ALL TIME)

hope this makes sense!

many thanks to anyone who takes a look