title: Counting rows with criteria and not counting the same row more than once
body: <p>So I'm looking to count how many rows contain the value "X" in at least one of 5 columns, and then exclude any of those rows that contain the same value in 2 different columns, but I'm not sure that my function is doing what I think it is.</p>
  
  <p>So basically this: "Get all rows that contain "X" in AT LEAST one of column A, B, C, D, E, then exclude any of those rows where value in column F is equal to value in column G"</p>
  
  <p>This is what I have, but I don't think it's right and the number I get seems very low:</p>
  
  <pre><code>=SUMPRODUCT((A1:A100="X")*(B1:B100="X")*(C1:C100="X")*(D1:D100="X")*(E1:E100="X")*(F1:F100&lt;&gt;G1:G100))
  </code></pre>