Inserting another column into current formula

[Patcheen]

How can i ad Column F to the current formula ? im trying to find how many games played at home without a loss

Column F is Home or away

this is my current formula

=MAX(FREQUENCY(IF(ISNUMBER(MATCH('Match Database'!$G$2:$G$5000,{"Won","Drew"},0)),IF('Match Database'!$H$2:$H$5000=AD42,ROW($I$2:$I$5000))),IF('Match Database'!$G$2:$G$5000="Lost",IF('Match Database'!$H$2:$H$5000=AD42,ROW($I$2:$I$5000)))))

im trying to ad column F i will be changing this for the away games also just by changing the word home to away


TIA

[Shareez Saleem]

Please attach a sample workbook with expected result.

[kvsrinivasamurthy]

May be this. Try.

=MAX(FREQUENCY(IF(ISNUMBER(MATCH('Match Database'!$G$2:$G$5000,{"Won","Drew"},0)),IF(('Match Database'!$H$2:$H$5000=AD42)*('Match Database'!$F$2:$F$5000="Home),ROW($I$2:$I$5000))),IF('Match Database'!$G$2:$G$5000="Lost",IF('Match Database'!$H$2:$H$5000=AD42,ROW($I$2:$I$5000)))))