identify specific cells in column possibly using count, offset, vlookup

I've attached a sample worksheet with 3 columns (B, C and D). What I need to do is get the answers in D (dark blue cells) without having to hard-code the formulas. I can't use a pivot table for this since this is going to be part of a workbook which has additional worksheets and lots of formulas which will be recalculated through multiple iterations using Solver.

I suspect the formula would involve Count, Offset and/or Vlookup, but not sure.

Please feel free to ask questions if this needs clarification, but I believe that if you look at the workbook, you'll immediately see what I'm referring to.


Thanks so much!

Sorry, can you show how you're arriving at example values in column D. Not sure what's being subtracted from what.
Please just upload a revised workbook. Thanks-Lee

Sorry about that! My brain isn't working too well today. I've modified the worksheet which now hopefully explains what I'm trying to do.

If you click on the numbers you see in column D you'll see my desired numbers.

I've also posted some notes on the worksheet which go into further detail.

Its beginning to become clear to me that the solution will involve something which "finds" the row number of the most recent
number in column D, then sums everything in column C down to the row number of the formula itself.

Hope that makes sense.

Thanks !

Hi all- Paste this in D9 and copy down:
=IF(C9,SUM(INDEX(B$8:B8,MATCH(1,INDEX(0/(C$8:C8>0),))):B8)-C9,"")

Thanks to both of you!

You're most welcome, and thank you for the rep!