Hi Marcus,
I was offering a solution.
The problem being when summing a series if any member is #DIV/0!
The result is #DIV/0!.
A simple solution is to sum the series in an available adjacent column.
If the amount shown in the original summation column is a number
enter the number in the new
As a Calc user with next to no programming experience, my solution for
#DIV/0! is simple.
In summing a series, in an available column , for amounts - enter the
/amount/.
For #DIV/0! - enter 0. To enhance ease and accuracy maintain relative
positioning.
Love Calc.