title: SUMIFS with AND and OR
body: <p>I've tried, I think most of the answers here, but I can not get them to work in my situation. </p>
  
  <p>Translated to text, my problem would looked like this : </p>
  
  <p>Sum Y:Y column with</p>
  
  <ul>
  <li><p>condition 1 : Column B:B if string starts with "15*"</p></li>
  <li><p>condition 2 : Column T:T must be greater then 0</p></li>
  <li><p>condition 3 : OR (value from column U:U = 0 OR U:U > V:V )</p></li>
  </ul>
  
  <p>Put in <code>SUMIFS</code> function, in theory, it would looked like this <code>SUMIFS(Y:Y,B:B,"15*",T:T,"&gt;0",or(U:U,"=0", U:U&gt;V:V))</code>,
  but of course it doesn't work like that.</p>
  
  <p>Also I've tried <code>SUMPRODUCT</code> and <code>SUM(SUMIF</code>...but I don't know how to translate what I like to accomplish into these two.</p>
  
  <p>So please, if someone knows how to make this work. And some explanation please.</p>
  
  <p>Thanks.</p>