總和 單元格多日期 (14554)

G2:H7=SUM(MMULT(N(IFERROR(TRIM(MID(SUBSTITUTE($E2,",",REPT(" ",99)),{1,2,3}*99-98,99))-$A$2:$A$16,9)=0),{1;1;1})*($B$2:$B$16=$F2)*$C$2:$C$16^($F$1=F$1))



留言