I had to replace this post with a better and I hope correct formula unless a better solution comes up.
Enter the following formula in:
E1 = C1-D1
E2 = SUM($C$1:$C2)-SUM($D$1:$D2), copy the formula down the rows in Col E.