Hi all experts,

I have a formula as follow:
=SUMPRODUCT((AX2:CU198>AY1-1)/COUNTIF(AX2:CU198,AX2:CU198&""))

I want to make it only shows the result in filtered cells. Please help! Thanks very much!!!