title: Excel, sum if a row value matches a vlookup value on another sheet
body: <p>Is it possible to sum all values in a column, based on a criteria checked against on another sheet?</p>
  
  <p>I have two sheets, one with values, one with manufacturers.  I would like check if the manufacturer has any value other than "YES" on another sheet and then sum if not equal to "YES".  The end result is a total for all manufacturers that do NOT have a value of "YES" on Sheet 2.</p>
  
  <p>In the example below I am trying to sum everything EXCEPT for Manuf B, a total of $1,132.</p>
  
  <p><a href="https://i.stack.imgur.com/8bUpw.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/8bUpw.jpg" alt="enter image description here"></a></p>
  
  <p>So far the formula I was working on (non functional) was:</p>
  
  <pre><code>=sumif(vlookup(C5:C12,'SHEET 2'!E5:F8,2,false),not("YES"),B5:B12)
  </code></pre>