Calculate % on time deliveries for team

Camilla Sugiarta

Hi,

I was able to use the following formula to count the % of on-time deliveries per team member.

=COUNTIFS([Work Days Between Due date and Date sent]:[Work Days Between Due date and Date sent], <=1, Reviewer:Reviewer, "ABC") / COUNTIF(Reviewer:Reviewer, "ABC")

We have several team members, so what formula could I use to calculate the % of on-time deliveries for all of the reviewers?

Thanks!

Genevieve P.

Hi @Camilla Sugiarta

This will depend a bit on how your sheet is set up, but essentially you could count the number of tasks that are less-than-or-equal-to-1 (as you have above, but without the Reviewer criteria), then divide this by the total number of tasks, counting perhaps the non-blank cells in your primary column?

Try This:

=COUNTIF([Work Days Between Due date and Date sent]:[Work Days Between Due date and Date sent], <=1) / COUNT([Primary Column]:[Primary Column])

If this doesn't work, it would be helpful to see a screen capture of how your sheet is set up, but please block out any sensitive data.

Cheers!

Genevieve