calculating percent delivered in a certain time frame

[Mingeita]

Hi,

I have sheet where quantities of items are ordered on a given date.
They're then delivered on various dates. Some can be delivered quickly, others no so.

I really need a way to find out, for a given order date, what percentage of the total quantity was delivered in a certain time frame, e.g. < 1 day, < 7 days
Can't think of way to do this with either formula or pivot.

So for example, in attached file.
For order 01/05/2022 42 items were ordered (sum of col c)
19 items were sent within a day which is 45.3%

[JohnTopley]

Try

=SUMPRODUCT(($E$3:$R$8)*($E$2:$R$2<=$A3+1))/SUMPRODUCT(($C$3:$C$17)*($A$3:$A$17=$A3))

Change highlighted as required e.g 7 for delivery within 7 days

[Mingeita]

Fantastic. Thank you so much