Calculate Completion Rate of Completed Courses

Dennis Leal 1 Reputation point
2022-10-31T20:41:58.44+00:00

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

Microsoft 365 and Office | Excel | For business | Windows
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Charles Qi_MSFT 976 Reputation points
    2022-11-01T02:16:11.423+00:00

    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.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.