I'm not getting any error messages but can't get this to sum column E with two criteria in column C. It will only sum for "Z001" and ignores "Z003".
=SUMIFS(Rejects!$E$2:$E$65,Rejects!$B$2:$B$65,$L$1,Rejects!$D$2:$D$65,$O$1,Rejects!$A$2:$A$65,I10,Rejects!$C$2:$C$65,{"Z001","Z003"})
Any ideas? Thanks!
=SUMIFS(Rejects!$E$2:$E$65,Rejects!$B$2:$B$65,$L$1,Rejects!$D$2:$D$65,$O$1,Rejects!$A$2:$A$65,I10,Rejects!$C$2:$C$65,{"Z001","Z003"})
Any ideas? Thanks!