Often you may want to calculate the completion percentage of a project in Excel.
This tutorial provides two examples of how to calculate completion percentage in different scenarios.
Example 1: Calculate Percent Complete Based on Missing Cells
Suppose we have a list of tasks along with their status in Excel:
To calculate the percentage of tasks that we’ve completed, we can use the following formula:
=COUNTA(B2:B11)/COUNTA(A2:A11)
We’ll type this formula into cell D2 and then press Enter:
From the output we can see that 0.3 or 30% of the tasks have been completed.
To format the number as a percentage, click the Number Format dropdown menu on the Home tab in Excel and choose Percentage:
The number will automatically be formatted as a percentage:
Note that the COUNTA function counts the number of cells in a range that are not empty.
Thus, in this formula we are simply counting the number of non-empty cells in the Status column and dividing by the number of non-empty cells in the Task column to come up with a completion percentage.
Example 2: Calculate Percent Complete Based on Text in Cells
Suppose we have a list of tasks along with their status in Excel:
To calculate the percentage of tasks that have a status of “Done”, we can use the following formula:
=COUNTIF(B2:B11, "Done")/COUNTA(A2:A11)
We’ll type this formula into cell D2 and then press Enter:
From the output we can see that 40% of the total tasks have been completed.
Additional Resources
The following tutorials explain how to perform other common tasks in Excel:
How to Find Percentage of Two Numbers in Excel
How to Calculate a Weighted Percentage in Excel
How to Calculate a Cumulative Percentage in Excel