=COUNTIF($D$5:$D$16,">"&IF(ISERROR(D5),0,D5))+1试试这个公式
=IF(ISNUMBER(D5),COUNTIF($D$5:$D$16,">"&D5)+1,"")
D列合计的公式用IFERROR函数处理一下公式中的错误
=COUNTIF($D$5:$D$16,">"&D5)+1，下拉填充
改该用代码？
