Hello and thanks for all that can help.
Trying to figure out C8
What C8 needs to do is look at C21-C386 and gather all the Mondays then grab all the Mondays Sales from AF21-AF386 and average that number.
I tried using the following but does not work.
=AVERAGEIFS(AF21:AF386,C21:CC21386,"Wednesday")
Attached Sheet
Bookmarks