Funds usage monitoring, weekly details

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.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. As you are new here, I shall do it for you this time: https://www.mrexcel.com/board/thread...tails.1217008/)

You will not be able to post links - please add one or two spaces to each link and then I will amend them for you.

Pleae be aware that people who make a habit of blanket bombing many fora with the same question tend to lose goodwill pretty rapidly: whilst it's not disallowed, it is viewed pretty dimly.

If you are in that much of a hurry for help, then you perhaps ought to consider finding a forum where you can pay for 24/7 and immediate 1-to-1 assistance.

https://techcommunity.microsoft.com/...632429#M164021

Thanks!