IF filtering on multiple string criteria, then MAX those results (might include a 0)

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!

Try this array* formula:

=MAX(IF((C$2:C$7="Frank")*(D$2:D$7="League"),F$2:F$7))

*An array formula needs to be committed using the key combination of Ctrl-Shift-Enter (CSE) instead of the usual <Enter>

Hope this helps.

Pete

Pete, that works perfect, thanks very much for the speedy reply!

Cheers

Glad to help.

If that takes care of your original question, please select Thread Tools from the menu above your first post and mark this thread as SOLVED.

Also, since you are relatively new to the forum, you might like to know that you can directly thank those who have helped you, and leave a private comment if you wish to, by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete