In this formula, the <> 3Z998 and <>35012106 are not being processed so the answer contains records with these values. =SUM(SUMIFS('SAI-41036-Q2'!$J:$J,'SAI-41036-Q2'!$D:$D,$D$68,'SAI-41036-Q2'!K:K,"<>35012106 ",'SAI-41036-Q2'!P:P,"<>3Z998 ",'SAI-41036-Q2'!$I:$I,{"55648 ","55644 "},'SAI-41036-Q2'!$F:$F,{"350110 ";"350120 "},'SAI-41036-Q2'!$M:$M,{"*\BLD"}))