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 column. If #DIV/0! Enter 0! sum as usual. To enhance ease and accuracy maintain relative positioning. In my Email I included the word amount in italics in your reply it became ////amount/./ Hope this helps.