排序 依指定日期的總和 (11845)

G3{=IFERROR(INDEX(A:A,RIGHT(LARGE(IF((COUNTIF(G$2:G2,A$3:A$16)=0),MMULT((A$3:A$16=TRANSPOSE(A$3:A$16))*TRANSPOSE(C$3:C$16=E$3),$B$3:$B$16)/1%+ROW($3:$16)),1),2)),"")

H3=IF(G3="","",SUMIFS(B:B,A:A,G3,C:C,E$3))