排序 四條件 (14942)

D2=IF(C2,COUNTIFS(B:B,B2,C:C,"<"&C2)-COUNTIFS(B:B,B2,C:C,0)+COUNTIFS(B$2:B2,B2,C$2:C2,C2),"")

另解=IF(C2,COUNTIFS(B:B,B2,C:C,"<"&C2,C:C,">0")+COUNTIFS(B$2:B2,B2,$C$2:C2,C2,C$2:C2,">0"),"")