title: How to solve functions error in LibreOffice Calc
body: <p>I am trying to do a split expenses in libreoffice calc and I have referred to others people template. However, my LibreOffice Calc keeps showing error of &quot;#value!&quot;.</p>
  <pre><code>=SUM(IF(NOT(ISBLANK(K5:K55)),(1/$H$5:$H$55)*$D$5:$D$55))-SUMIF($F$5:$F$55,K4,$D$5:$D$55)
  </code></pre>
  <p><img src="https://i.stack.imgur.com/G4Tmv.png" alt="enter image description here" /></p>