title: Statement for checking IF multiple cells CONTAIN certain text
body: <p>I have a column of values, and then I have two columns with simple marking like just an 'X':</p>
  
  <pre><code>     A              B               C
  1    
  2
  3    VALUES:       PERSON1:         PERSON2
  4    500           X
  5    180                            X
  6    100                            X
  7    200           X
  8    TOTAL:
  9    =SUM(A4:A8)   ??               ??
  </code></pre>
  
  <p>Can I create a statement that will check that if a box has an <code>X</code> in it the value of the A-column cell on the same row will be subtracted from the total summation?  </p>
  
  <p>In the example above PERSON2 should have a statement with the values '=980-180-100' which is <code>700</code>.</p>
  
  <p>I can easily do it for one cell: <code>=IF(B4="X", A9-A4)</code> but I can't quite get around with doing with multiple.</p>