countvisible SUMIF Frequency

[NeedExcelHelp2021]

I have a formula that works perfectly fine, though I would now like it to calculate only the visible cells when I apply a filter. The formula for identifying The Frequency of 3 or more positive values (ignoring blank cells)....
=SUM(IF(FREQUENCY(IF(LD6:LD116>0,ROW(LD6:LD116)),IF(LD6:LD116<0,ROW(LD6:LD116)))>=3,1))



Hope someone can help - Many thanks.

 

[Eric W]

Welcome to the forum!

Try:

=SUM(IF(FREQUENCY(IF((LD6:LD116>0)*(SUBTOTAL(102,OFFSET(LD6,ROW(LD6:LD116)-ROW(LD6),0))),ROW(LD6:LD116)),IF((LD6:LD116<0)*(SUBTOTAL(102,OFFSET(LD6,ROW(LD6:LD116)-ROW(LD6),0))),ROW(LD6:LD116)))>=3,1))

 

[NeedExcelHelp2021]

Worked Perfectly...?

Thank You