title: How to do excel formula that would Sum values from column C if column A is 'X' or 'Y' and column B is 'Z'?
body: <p>I have a spreadsheet from which I need to pick out some specific values that are in one of text columns but only if other column matches the year.</p>
  
  <p>I have tried following <code>SUM</code> with <code>IF</code> but I think <code>OR</code> portion in textual column is failing...</p>
  
  <p><code>=SUM(IF(B:B="*Nuoma*",B:B="*(Nuomininko)*",C:C=2016,D:D))</code></p>
  
  <p>What I need is if in column B value contains <code>Nuoma</code> OR <code>(Nuomininko)</code> AND column C is 2016 then SUM column D...</p>