Nested "sumif" statements?

[MN_Excel]

I'm basically trying to do two sumif statements into one formula. If the cell in column B is "sales" I want to add the amount in column C. However, even if the value in column B is "sales" I don't want to add the amount in column C if column A is either "discounts" or "returns." Not sure the easiest way to do this.

 

[MN_Excel]

Wow, formula worked perfectly. Thanks for the help, I really appreciate it.

 

[MN_Excel]

I'm once again using these "sumifs" and was hoping for a little troubleshooting help. The formula below is resulting in zero

SUMIFS($AB$94:$AB$4998,$Z$94:$Z$4998,"Strategic",$Z$94:$Z$4998,"Support")

If I take out the second argument ("support") the formula will acccurately sum all those items in column Z with "Strategic". Likewise, when I remove the "strategic" criteria it is accurate in summing the "support" items. Problem is that when I put them together I am getting zero and can't figure out why.

 

[MrVillareal]

you can't use sumifs that way because you are refering to one column for criteria range with 2 criteria. try:

=SUMPRODUCT(($AB$94:$AB$4998)*($Z$94:$Z$4998={"Strategic","Support"}))