Funds usage monitoring, weekly details

[marchandarme]

Dear community,
I am coming to you with an excel problem that I am sure will challenge you. I am not sure what I expect is possible to compute though.

I am a reseller.
T buy what I sell, I send money to my purchasers in order for them to buy me some specific electronic components.
If I send him 1 of money, it means the money for one electronic component; when he purchases for 1, it means he bought one component (= all in the same unit).
I record weeks after weeks the amount of money I have send, and the purchases he has made. I then track the cumulative funding and purchase figures, for the specific weeks and as a cumulative.
The Outstanding equals to the cumulative funding minus the cumulative purchases (= the available money for him).
If I compute this data, here is how it would look (very simplified data):

Capture.PNG

I have compute what I am explaining in a file I put at your disposal.
What I would like to do is a summary of the number of weeks my purchaser has money at hand that he hasn?t converted to coco, but with further details. Let me explain.
If I use a count if formula of the all-time cumulative funding > to the current week cumulative purchase, (Column ?Countif? in the file) I?ll get the amount of weeks since my purchaser has money that hasn?t been converted.
However, what I would like is to split the outstanding amount into the count if result I have. Let?s say my count if equals to 4, I would like to know which part of my outstanding comes from 4 weeks ago, which part come from 2 weeks, which part comes from the previous week?
I have a range of weeks I am interested in. I computed in the file the data you could use, and the expected result written manually.

Capture2.PNG

I am not sure such a computation is possible on excel, however I require your excel brilliancy to crack this case, I don?t think it?s an easy one..
Thank you very much.