F2=LOOKUP(9E+307,$A$2:A2)
下拉公式
选定D列，按CTRL+G
定位条件，选择 空置
复制=COUNTIF(INDIRECT("C"&MATCH(A2,A:A,)):INDIRECT("C"&COUNTIF(INDIRECT("f"&MATCH(A2,A:A,)):F1000,A2)+1),"A")*100+COUNTIF(INDIRECT("C"&MATCH(A2,A:A,)):INDIRECT("C"&COUNTIF(INDIRECT("f"&MATCH(A2,A:A,)):F1000,A2)+1),"b")*80+COUNTIF(INDIRECT("C"&MATCH(A2,A:A,)):INDIRECT("C"&COUNTIF(INDIRECT("f"&MATCH(A2,A:A,)):F1000,A2)+1),"c")*60+COUNTIF(INDIRECT("C"&MATCH(A2,A:A,)):INDIRECT("C"&COUNTIF(INDIRECT("f"&MATCH(A2,A:A,)):F1000,A2)+1),"d")*40
同时按 CTRL+回车键
