sumifs and ??|General Excel Questions & Answers|Excel Forum|My Online Training Hub

Hello,

I have a question about a formula.

I currently have the following formula on the invoice master tab, in column I, row 8

=SUMIFS('Skidtags Master'!U:U,'Skidtags Master'!F:F,A7,'Skidtags Master'!G:G,B7,'Skidtags Master'!S:S,$I$5,'Skidtags Master'!AL:AL,"<>TO BINDERY")

Which brings in the answer 1219.

But internally we have added waste to this number that we need to decrease from the total quantity ordered from customer. 

I would like to know if there is a way to add in something similar to:

“If column “AD” = 44, take out 400 from the total quantity”. So my answer would be 819.

Thanks

Amy