Calculate % on time deliveries for team
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?
Help Article Resources
Check out the Formula Handbook template!