G3{=IFERROR(TEXT(INDEX(B:B,SMALL(IF(C$2:C$20>C$3:C$21,ROW($3:$21)),ROW(A1))),"YYY/M/D")&"-"&TEXT(INDEX(B:B,SMALL(IF(C$3:C$21>C$4:C$22,ROW($3:$21)),ROW(A1))),"YYY/M/D"),"")
H3=IF(G3="","",SUMIFS(C$3:C$21,B$3:B$21,">="&LEFT(G3,FIND("-",G3)-1),B$3:B$21,"<="&MID(G3,FIND("-",G3)+1,9)))
留言
張貼留言