The NULL values are caused by a missing number, element, formula and the hastag is displayed every time there is an error in the calculation. If you use a formula, check the elements contained in the SUM. No, you can't mark the NULL values as zero since they contain errors.