區域小計 符合二數之間 (12145)

C5=SUMIFS(C$1:C4,C$1:C4,">="&E$2,C$1:C4,"<="&F$2,B$1:B4,"")-SUMIF(B$1:B4,"小計",C$1:C4)

C5複製到小計右邊



留言