Calculate Completion Rate of Completed Courses

Question

Hi All,

I have a small excel problem im just a beginner and would like some guidance on how to solve this.

I have a unique list of names in column B and the courses names are in Columns M, N, O right below them are the status of the courses that was assigned to our employees
the value under Columns M, N, O are "Not Ready, Completed, In Progress" we would like to display the completion rate of each employees be displayed in Column P.

Any Help would be greatly appreciated

Answer 1

Hi @Dennis Leal

You can apply =N2/(M2+N2+O2) in P2 then change the value in Percent style, then drag down to other cells in the column.

---

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in email-notifications to enable e-mail notifications if you want to receive the related email notification for this thread.