title: Using OR Logical functions with SUMIFS in Excel
body: <p>I have two workbooks in excel which I copy columns from one to the other.
  I would like to copy the number of one column, say A, IF another column, say B, is equal to "Test Tool" or "Hard Tool". I've written this code and can't get it to work, it just gives me the sum zero which is wrong. The last argument doesn't matter so ignore it.</p>
  
  <pre><code>"=SUMIFS('Tooling forecast template'!R6C17:R500C17,'Tooling forecast template'!R6C7:R500C7,""OR(=Test Tool, =Hard Tool)"" ,'Tooling forecast template'!R6C6:R500C6,""&lt;&gt;Actual tool/equipment change"")"
  </code></pre>