If multiple entries, sum of entries, but in order by date

Hello,

Is it possible to calculate the following table correctly.

excelexample.jpg

I want to calculate the projected balance of expired material when there's multiple entries, currently calculations is just based off column E "total remaining days".

Row 2 is being used first and will expire in 2 days. Row 3 has 22 days remaining, but it won't be used until the first row is used up so actually when it does start there will be 20 days remaining with the same amount of inventory. Row 4 will have 40 day remaining when it starts being used.

I would like to use this formula on a list of materials and was thinking to use count to locate multiple entries.

IF Count >1 minus "total remaining days" of "earliest date" from "second date", then "total remaining days" of "second date" from "third date", etc.

Hello & Welcome to the Forum,

A possible solution. Insert a column after column E and then use...

=E3-SUM($E$2:E2)

...copied down

Or if you have other products other than wheat and there is a possibility that the dates may not always be listed from earliest to latest this is more complex but a little more robust

=E2-SUMPRODUCT(--($D$2:$D$6<D2),$E$2:$E$6,--($B$2:$B$6=B2))

and copied down