Calculate Completion Rate of Completed Courses

Dennis Leal 1 Reputation point

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,413 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Charles Qi_MSFT 956 Reputation points

    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.