EXCEL sum和sumifs不包括多个单词

The formula I am entering below works only with one condition I use the <> sign in example 1. The problem I have is when I enter two <> as shown in example 2 it doubles my total value and doesn’t work. How would I enter two <> conditions to get a dollar value for revenue? For example my revenue result will be 75,000 in example one, but in example 2 I get 150,000. Don’t understand what is happening. Probably a simple mistake I am making.The formula I am entering below works only with