第1个回答 2022-05-07
A2:
=INDEX(明细表!A:A,SMALL(IF(MATCH(明细表!A$2:A$10000&"",明细表!A$2:A$10000&"",)=ROW($2:$10000)-1,ROW($2:$10000),4^8),ROW(A1)))&""
ctrl+shift+回车
B2:
=IF(A2<>"",SUMIF(明细表!A:A,A2,明细表!C:C),"")
C2:
=IF(A2<>"",SUMIF(付款表!B:B,A2,付款表!C:C),"")
全部下拉1000行本回答被提问者采纳