How To Calculate Project Complete Percentage In Excel

How to Calculate Project Complete Percentage in Excel

A project is often divided into smaller tasks. When each task is completed, we say that project is completed 100%. In that case we would  like top monitor how task is completed while we work on the project. In this article, we will learn how you can calculate the project complete percentage in Excel

Generic Formula For Project Complete %

=COUNTIF(status range,“finished”)/COUNTA (tasks range)

Status range : It is the range in which status of task is written.

Finished: Here “finished” word is used when a task of project is completed. You can use any word you want.

Tasks range : The range in which tasks are listed

Let’s see an example to make things clear. Example: Calculate Project Complete Percentage in Excel Here I have a list of tasks in range A3:A14. Their status is written in range B3:B14. We need to calculate percent complete in excel.

Apply above generic percent complete formula

=COUNTIF(B3:B14,"finished")/COUNTA(A3:A14)

It will return a fraction number. Change the formate to percentage using excel shortcut CTRL+SHIFT+5. And it’s done. How it works?

Well, it is a simple excel formula. We count the number of completed tasks in excel using COUNTIF(B13:B14, “finished”).

Than we divided the number of completed tasks from total number of tasks using /COUNTA(A3:A14). Finally we formated that cell as percentage. And that is it. We have calculated percentage of project completion in excel using a simple formula. So yeah guys, this how you calculate total percentage in excel. Let me know if you have any doubts regarding this excel topic or any other. The comments section is all yours.

Related Articles

Calculate Percentage of Total in Excel

Calculate Percentage Discount

Increase by percentage

Calculate Profit margin percentage

Popular Articles:

The VLOOKUP Function in Excel

COUNTIF in Excel 2016

How to Use SUMIF Function in Excel