I've been banging my head against this for a few days now for my sons hockey team and have gotten nowhere so any help would be very much appreciated!
In this example I need to match all games played by "Frank" that are "League" games and find the MAX value of 1stPeriodGoalsAgainst
A B C D E F G 1 Game Home/Away Goalie Type 1stPeriodGoalsFor 1stPeriodGoalsAgainst 2 1 Home Frank League 2 0 3 2 Away Tom League 1 3 4 3 Home Frank Tournament 0 0 5 4 Away Frank Tournament 2 2 6 5 Home Tom League 1 4 7 6 Away Frank League 3 0
Since there is no MAXIFS function I've tried various forms of MAX IF and IF MAX to hit on the search criteria and retrieve the MAX value of that particular column
Thanks in advance!
Bookmarks