Adding a column to 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

 

[Patcheen]

any ideas be helpful TIA

 

[Patcheen]

hi all

any help be brill thank you

 

[Patcheen]

Any ideas?