formula - How to solve functions error in LibreOffice Calc

Question

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 "#value!".

=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)

Answer 1

It seems that you want an array operation. Finish the edit of the formula with Ctrl-Shift-Enter, see Array Functions.