# How to Calculate Percent Complete in Excel

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.