Calculating % on-time vs late delivery

Camilla Sugiarta

Hello,

I am trying to calculate the % of items we deliver on-time and % of items we deliver late. I have a column where I calculated the "average no. of days between due date and completion date" and a column for the team members name.

For % on-time deliveries, I think that I need to only grab the cells that have "average no. of days between due date and completion date" less than or equal to 0, for that team member. What would this formula look like?

And for % late deliveries, I think I just need to change the "less than 0" to "greater than 0".

Thanks!

John Jonassen

Try this:

On Time Deliveries

=countifs([Average No. of Days Between Due Date and Completion Date],<=0,[Team Member Column],Team Member's Name)/countif([Team Member Column],Team Member's Name)

Late Deliveries

=countifs([Average No. of Days Between Due Date and Completion Date],>0,[Team Member Column],Team Member's Name)/countif([Team Member Column],Team Member's Name)

Camilla Sugiarta

Thank you!