Quote:
Originally Posted by Marcia
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.
|
Hi Marcia,
Thanks so much for that. I found this worked well. I found I could enter the full formula in row 1 and copy it down without the need for the first shorter formula.
Also, I found it worked with my added...
=IF(AND(ISBLANK(C4),ISBLANK(D4)),"",SUM($C4:$C$4)-SUM($D4:$D$4))
so that the balance column remains blank under the last entry. I'm fussy like that.
Now I just need to figure out why it works to deeper my learning a little bit!