加總 單格二條件數字 (14038)

D3:F5{=TEXT(SUM(IFERROR(ISNUMBER(FIND($C$2&" "&$C3,$A$3:$A$10))*ISNUMBER(FIND(D$2,$A$3:$A$10))*MID(SUBSTITUTE($A$3:$A$10,",",REPT(" ",99)),COLUMN($A:$I)*99-98,99),)),"0;;")



留言