Need to make a service level scorecard

Perhaps something like this ...
In say, G2: =SUMPRODUCT((A2:A5=A2)*(C2:C5-D2:D5>=3)*(D2:D5<>""))
where col A = Supplier ID, col C = Arrival dates, col D = Docs received dates
Expression counts the # of shipments that meet the SL (>=3 days) for a specific supplier (in A2)

Then in H2: =SUMPRODUCT((A2:A5=A2)*(D2:D5<>""))
returns the total shipments for that specific supplier with (valid) dates in col D
Hence, in I2: =G2/H2 returns the SL% for that specific supplier
---------------------------------------------------
Any good? Wave it, hit the little star at the bottom left of my responses