In Libreoffice Calc, sometimes the SUM function returns ### in the cell when referencing other sums. For example:
in the output cell. (obviously this is not my real data)
Sometimes the function outputs correctly if I re-make it. It also tends to error like this when I change the values of the referenced cells.