How to Calculate Percent Complete in Google Sheets


Often you may want to calculate the completion percentage of a project in Google Sheets.

Fortunately this is easy to do and the following two examples show how to do so in different scenarios.

Example 1: Calculate Percent Complete Based on Missing Cells

Suppose we have a column of tasks along with their status in Google Sheets:

To calculate the percentage of tasks that have been completed, we can type the following formula into cell D2:

=COUNTA(B2:B11)/COUNTA(A2:A11)

The following screenshot shows how to do so:

From the output we can see that 0.3 or 30% of the tasks have been completed.

Note that the COUNTA function counts the number of cells in a range that are not empty.

Thus, in this formula we count the number of non-empty cells in the Status column and divide by the number of non-empty cells in the Task column to calculate the completion percentage.

Example 2: Calculate Percent Complete Based on Text in Cells

Suppose we have a column of tasks along with their status in Google Sheets:

To calculate the percentage of tasks that have a status of “Done”, we can type the following formula into cell D2:

=COUNTIF(B2:B11, "Done")/COUNTA(A2:A11)

The following screenshot shows how to do so:

From the output we can see that 30% of the total tasks have been completed.

Note: Feel free to click the Format as Percent icon along the top ribbon in Google Sheets to display the decimal as a percentage value.

Google Sheets calculate percent complete

Additional Resources

The following tutorials explain how to perform other common tasks in Google Sheets:

How to Calculate Percentile Rank in Google Sheets
How to Calculate Average Percentage in Google Sheets
How to Calculate the 90th Percentile in Google Sheets

Leave a Reply

Your email address will not be published. Required fields are marked *