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
|