Thanks JE,

IT works perfectly,





Dave




JE McGimpsey wrote in
:

Yeah, I didn't think that through very well. Try this in D3, and copy
down:

=SUMPRODUCT(--(C3$J$2:$J$4),(C3-$J$2:$J$4),$L$2:$L$4)-SUM(D$2:D2)

In article ,
asdfasdf wrote:


One problem is with the cells for future months with nothing entered.
Here is what I get.


Monthly YTD running total Amt Owed
50000 50000
15000 49000 99000
14700 11000 110000
18600 0 110000 14700
0 110000 18600
0 110000 14700
0 110000 18600
0 110000 14700