subtracting cells from next value

Hi, hopefully the attached worksheet will do what you're looking for.
Cells in column D need to be entered as an array (Ctrl-Shift-Enter).
And Row 1 needs to be empty.

BEamernsw,

Thank you for the doc.. it almost works.. I had to add some column to my table and I am getting the following...

A LITTLE CONFUSED AS TO WHY THIS IS HAPPENING.

Thanks for your help!!

Hi, its because my formula is checking if the cell in column F is blank, but you have a 0 in there.

So change the first "" to 0 and if you wish to have a 0 in column G as well then also change the last "" to 0.

=IF(F3<>0,F3-SUM(INDIRECT("C"&MAX(IF(G$2:G2<>"",ROW(G$2:G2)))+1):C3),0)