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

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,639 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Charles Qi_MSFT 966 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.