title: Excel Formula Sum
body: <p>I’m trying to make a formula in excel which will sum all the values in S which have a Yes in column K. I have written this formula but it only gives me the value 0. In between the values in S I have some cells with text and I have already tried if it would work if I delete those but still, it only gives me the value 0.</p>
  
  <pre><code>=SUMIF(K7:K120;"Yes";S7:S120)
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/tDIFX.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/tDIFX.png" alt="Image"></a></p>