Can you add a condition to a MAX Frequency formula

[Marvo]

Can you add a condition to a Max frequency formula or do the rows have to be consecutive for it to work please? I'm suspecting the latter.

I've got this array formula that works

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

then I added a further condition and it doesn't, well at least not with the correct result..

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