總和 多條件 (9446)

B4:C7{=IFERROR(INDEX(L:L,MATCH(1,(COUNTIF($B$3:$B3,$L$2:$L$16)=0)*($P$2:$P$16=$B$2)*($O$2:$O$16>=$G$1)*($O$2:$O$16<=$I$1),)+1),"")

D4:D7=IF(B4="","",SUMIFS(N:N,L:L,B4,O:O,">="&$G$1,O:O,"<="&I$1,P:P,B$2))

F4:G7{=IFERROR(INDEX(L:L,MATCH(1,(COUNTIF($F$3:$F3,$L$2:$L$16)=0)*($P$2:$P$16=$F$2)*($O$2:$O$16>=$G$1)*($O$2:$O$16<=$I$1),)+1),"")

H4:H7=IF(F4="","",SUMIFS(N:N,L:L,F4,O:O,">="&$G$1,O:O,"<="&I$1,P:P,F$2))