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