Can you add a condition to a MAX Frequency formula

Hi, I've added a cut down version of my workbook. The working I showed is in cells J91, J92 & J93. The formula produced by samba-ravi is in K91, K92, K93 which produces a incorrect result of 1. The correct result (worked out manually) is in C91, C92 & C93. Many thanks for taking an interest.

Originally Posted by Bo_Ry

Please try

Home WINS
=MAX(FREQUENCY(IF(ALL!$E$2:$E$5400="H",IF(ALL!$J$2:$J$5400="W",ROW(ALL!$J$2:$J$5400))),IF(ALL!$E$2:$E$5400="H",IF(ALL!$J$2:$J$5400<>"W",ROW(ALL!$J$2:$J$5400)))))

Home DRAWS
=MAX(FREQUENCY(IF(ALL!$E$2:$E$5400="H",IF(ALL!$J$2:$J$5400="D",ROW(ALL!$J$2:$J$5400))),IF(ALL!$E$2:$E$5400="H",IF(ALL!$J$2:$J$5400<>"D",ROW(ALL!$J$2:$J$5400)))))

Home DEFEATS

=MAX(FREQUENCY(IF(ALL!$E$2:$E$5400="H",IF(ALL!$J$2:$J$5400="L",ROW(ALL!$J$2:$J$5400))),IF(ALL!$E$2:$E$5400="H",IF(ALL!$J$2:$J$5400<>"L",ROW(ALL!$J$2:$J$5400)))))

That works a treat. Thank you so much. I'm now going to try and learn how this works in order to finish the workbook. I'm very grateful.

Of course. The array formulas in C81 to C90 work out consecutive runs of wins, draws and losses, goals scored, conceded of football matches throughout the history of Northampton Town FC. They work fine.
I'm now trying to add the condition of looking at matches played at HOME. I think I could do it with a separate sheet easily enough but if I can do it with a formula that would be preferable.

I'll next be looking to add AWAY matches, then further down the line just league matches (non-cup)

Sorry, I've managed to get a lot further with this, changing the "H" to "A" and then "H" to "League" but need to put them together to add a final condition and am struggling. I've ended up with this

=MAX(FREQUENCY(IF(ALL!$I$2:$I$5400="League",ALL!$E$2:$E$5400="H",IF(ALL!$J$2:$J$5400="W",ROW(ALL!$J$2:$J$5400))),IF(ALL!$I$2:$I$5400="League",ALL!$E$2:$E$5400="H",IF(ALL!$J$2:$J$5400<>"W",ROW(ALL!$J$2:$J$5400)))))

I'm thinking where I add the "league" to the "H" is wrong in the initial IF condition?

What I am asking is, If the match is a league match and if the match was played at home, then what is the most consecutive wins.

Sorry Glenn, I've added the updated attachment. It's column C on the summary page. I've got down to C123 where I've hot the stumbling block adding the further condition. The correct result is shown in M123 which I did by manual inspection.

Thanks Glenn, much appreciated. I should be able to finish it from here.