Counting frequency between 2 zeros

[Patcheen]

Is it poss convert this formula from frequency of clean sheets in a row to scored in a row (as in scoring in as many games as poss without missing)

=MAX(FREQUENCY(IF('Match Database'!$D$5:$D$500=0,ROW('Match Database'!$D$5:$D$500)),IF('Match Database'!$D$5:$D$500<>0,ROW('Match Database'!$D$5:$D$500))))

in the sample image the answer is 9 thats counting between the 2 zeros

Hope this helps

TIA

 

[Fluff]

Just change the = & <> signs around.

 

[Patcheen]

Just change the = & <> signs around.

done that in the original workbook where i have a 17 between 2 zeros but it returned 15. thank you for your help

 

[Fluff]

Can you post some actual data that shows the problem.

 

[Patcheen]

Just change the = & <> signs around.

Gotr it my fault apologies.... i had to change the 500 to 5000 my oversight thank you

 

[Fluff]

Glad it's sorted & thanks for the feedback.