adding more to formula

[Patcheen]

this formula works perfect until i add more to it
=MAX(FREQUENCY(IF(ISNUMBER(MATCH('Match Database'!$H$2:$H$5000,{"Won","Drew"},0)),ROW('Match Database'!$H$2:$H$5000)),IF('Match Database'!$H$2:$H$5000="Lost",ROW('Match Database'!$H$2:$H$5000)))) (which is an array formula)

=MAX(FREQUENCY(IF(ISNUMBER(MATCH('Match Database'!$H$2:$H$5000,{"Won","Drew"},0)),ROW('Match Database'!$H$2:$H$5000)),IF('Match Database'!$H$2:$H$5000="Lost",ROW('Match Database'!$H$2:$H$5000)))),IF('Match Database'!$H$2:$H$5000="Lost",ROW('Match Database'!$h$2:$h$5000),ROW('Match Database'!$g$2:$g$5000,"home") it says you have entered too many arguments for this function......

so what am i missing

TIA

 

[ClaireS]

This section

=MAX(FREQUENCY(IF(ISNUMBER(MATCH('Match Database'!$H$2:$H$5000,{"Won","Drew"},0)),ROW('Match Database'!$H$2:$H$5000)),IF('Match Database'!$H$2:$H$5000="Lost",ROW('Match Database'!$H$2:$H$5000))))
has an equal number of open/close brackets so by the end of this, your MAX function has finished. You then have your IF sort of stuck on in limbo. I suspect you should delete the final bracket of the bit I have quoted and put it at the end of your function.​

 

[Patcheen]

thank you as i stated that works fine without this ,ROW('Match Database'!$g$2:$g$5000,"home i want to add that to it but when i do i get "you have entered too many arguments for this function......"

 

[ClaireS]

Looks like you need to use the MATCH function as you did in the first bit of your formula after ISNUMBER. As you have it now, the new bit has two arguments in the ROW function: the range and the word "home".

 

[ClaireS]

The ROW function expects just a number. It won't accept the "home". I think you need to use the INDIRECT and MATCH functions to find the position of the value of "home" in column Q. Something like:
=ROW(INDIRECT("Q" & MATCH("home",

'Match Database'!$g$2:$g$5000​

)))+1
The +1 is to give you the actual row number as you are looking from row 2, but you could probably use Q:Q and omit the +1.

 

[ClaireS]

Ignore my message #4 .