You can switch to AVERAGEIFS, i.e. existing (single condition) formula would change such that the average range is now listed first.
The below accommodates your various criterion and, with exception of Venue, will handle blank criterion as "all".
Notes:
For "Venue" I would suggest doing following: leave criteria blank, rather than space, to handle "home" -- for "all" enter * in criteria (rather than blank [=home])
rationale: 'home' fixtures on college tabs are blanks as opposed to spaces.
To negate need for double test on 'days between games' enter 0 in S3 on each college tab
rationale: to handle "all" devoid of these 0s you would effectively need to test both text & numbers (double the testing)
Bookmarks