DATEâ â³ï¼ç¾âåâç½ï¼'å¯æ¥â³æ¡ä¾´å£ç¢âä»·æ ¼âä¸å®⋅è¦æ³¨æâ³é¿å• =--TRIM(MID(SUBSTITUTE($A2," ",REPT(" ",100)),COLUMN(A:A)*100-99,100))=VALUE(TRIM(MID(SUBSTITUTE($A2," ",REPT(" ",100)),COLUMN(A:A)*100-99,100))) =IF(C3=2,0,"")&SUBSTITUTE(SUMPRODUCT((C3:L3=2)*C$2:L$2*10^(9-COLUMN(A:J))),"0","") =SUMIF(INDIRECT("'"&$B5&"'!A11:A19"),N$3,INDIRECT("'"&$B5&"'!B11:B19")) B1=IFERROR(LOOKUP(1,0/((Sheet1!$A$2:$A$100=$A2)*(Sheet1!$B$2:$B$100=B$1)),Sheet1!$C$2:$C$100),"")B2=IFERROR(VLOOKUP($A2&B$1,IF({1,0},1!$A$2:$A$17&1!$B$2:$B$17,1!$C$2:$C$17),2,0),"")
温馨提示：答案为网友推荐，仅供参考