=SUMIFS(D:D,A:A," & lt= " & amp$I$2,B:B,J2,C:C,K2)
L11單元格輸入公式:
=SUMIFS(D:D,A:A," & gt= " & amp$H$11,A:A," & lt= " & amp$I$11,B:B,J11,C:C,K11)
L20單元格輸入公式:
=SUMIFS(D:D,A:A," & gt= " & amp$H$20,A:A," & lt= " & amp$I$20,B:B,J20,C:C,K20)
復制並放下三個公式