排序 依起止日期間總和 (10672)

I7 下拉{=INDEX(B:B,RIGHT(MAX(IF((A$2:A$199>=J$2)*(A$2:A$199<=J$3)*(COUNTIF(I$6:I6,B$2:B$199)=0),SUMIFS(F:F,A:A,">="&J$2,A:A,"<="&J$3,B:B,B$2:B$199)/1%%+ROW($2:$199),999)),3))&""

J7 下拉=IF(I7="","",SUMIFS(F:F,B:B,I7,A:A,">="&J$2,A:A,"<="&J$3))