=SUMIFS(D:D,A:A," & lt= " & amp$I$2,B:B,J2,C:C,K2)
L 1 1 cell input formula:
=SUMIFS(D:D,A:A," & gt= " & amp$H$ 1 1,A:A," & lt= " & amp$I$ 1 1,B:B,J 1 1,C:C,K 1 1)
L20 cell input formula:
=SUMIFS(D:D,A:A," & gt= " & amp$H$20,A:A," & lt= " & amp$I$20,B:B,J20,C:C,K20)
Copy and drop three formulas.