title: EXCEL sum and sumifs excluding multiple words
body: <p>The formula I am entering below works only with one condition I use the &lt;> sign in example 1. The problem I have is when I enter two &lt;> as shown in example 2 it doubles my total value and doesn’t work. How would I enter two &lt;> 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.</p>
  
  <p>1)  =SUM(SUMIFS(Revdata!O:O,Revdata!N:N,Sheet2!B3,Revdata!J:J,{"&lt;>dog"}))</p>
  
  <p>2)  =SUM(SUMIFS(Revdata!O:O,Revdata!N:N,Sheet2!B3,Revdata!J:J,{"&lt;>dog","&lt;>cat"}))</p>