After several hours of study, I still can't make a right formula. The following is one I have tried, however it is surely wrong

=SUMPRODUCT((AX2:CU198>AY1-1)/SUMPRODUCT(SUBTOTAL(3,OFFSET(AX2,ROW(AX2:CU198)-MIN(ROW(AX2:CU198)),0,1))*(AX2:CU198=AX2:CU198)*(AX2:CU198="")))

Any masters can give me some help. Thanks!