title: Excel double negative operator with logical operators
body: <p>I've just learned about double operators and am wondering if you can add logical operators to increase the range looked at. For example if any cell in the range A1:A10 is less 10 AND any corresponding cell next to that particular cell in the range B1:B10 is greater than 5 then sum the values in the corresponding cell in the range C1:C10.
  This is clearly not correct, but I would have thought it would have been written something like this.</p>
  
  <pre><code>=SUMPRODUCT(--(AND(A1:A10&lt;10,B1:B10&gt;5)),C1:C10)
  </code></pre>
  
  <p>The normal -- function is:</p>
  
  <pre><code>=SUMPRODUCT(--(A1:A10&lt;10),C1:C10)
  </code></pre>