Calculate % on time deliveries for team
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!
Best Answer
-
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
Answers
-
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
-
It works! Thanks Genevieve!
-
That's great to hear! I'm glad it worked for you 🙂
Help Article Resources
Categories
Check out the Formula Handbook template!