While working in Microsoft Excel, you might need to calculate the percentages of a project’s completion so that your final report looks impressive. This often creates difficulties while calculating. But no more from today. In this article, I am sharing with you how to calculate the percentage of completion in Excel.
How to Calculate Percentage of Completion in Excel: 3 Quick Methods
In the following, I have explained 3 quick and simple tricks to calculate the percentage of completion in Excel. Stay tuned!
Suppose we have a dataset with some Dates, Tasks needed to be completed, and their Status explaining whether are those completed or not. Now we will calculate the percentage of completion from this table.
1. Use COUNTA Function to Calculate Percentage of Completion
If you are looking for a simple solution to calculate the percentage of completion in a quick way then you are at the right place. Here, I am gonna show you a simple way to apply the COUNTA function. The COUNTA function will count blank cells in a range in this list.
Steps:
- First, select a cell (F5) and apply the following formula down-
=COUNTA(D5:D12)/COUNTA(C5:C12)
Here, COUNTA(D5:D12) counts the number of non-blank cells (the string Complete in this case) and similarly, COUNTA(C5:C12) counts the non-blank cells (total number of Tasks). Then the earlier result will be divided by the later output to produce the final result.
- Next, hit ENTER.
- Finally, we have successfully calculated the percentage of completion in our Excel worksheet.
2. Manual Formula to Calculate Percentage of Completion
Often we face difficulties making a report where we have to calculate the percentage of completion of tasks, students obtained marks, etc. It won’t be a problem anymore from now. In this method, I will show you an easy trick to calculate the percentage of completion with a basic mathematics equation.
Suppose we have a dataset of some Students’ Names, Their Obtained Marks in multiple subjects, and their Total Marks. Now we will calculate the percentage of these students who obtained marks.
Steps:
- Presently, we will determine the total obtained mark of each student. To do that, select a cell (G8) and write the following formula down-
=C8+D8+E8+F8
- Gently, press ENTER and drag the “Fill Handle” down to fill all the cells.
- Next, choose another cell (H8) and apply the below formula-
=G8/$C$4
- Similarly, press ENTER and pull the “Fill Handle” down. Make sure to apply the absolute cell reference to the cell which needs to remain consistent.
- In summary, our desired output calculating the percentage of each student obtained mark will be in our hands. Here, you can see the percentage of total marks each student has achieved.
3. Combine COUNTIF and COUNTA Functions
With the combination of the COUNTIF and COUNTA functions, you can calculate the percentage of completion too. Just follow the instructions below-
Steps:
- To start with, choose a cell (F5) and apply the formula below-
=COUNTIF(D5:D12,"Complete")/COUNTA(C5:C12)
Where,
- The COUNTIF function will count cells with the given condition- “Complete” in the argument.
- The COUNTA function will count cells containing any type of information in this range.
Then the earlier result (result from COUNTIF) will be divided by the later output (result from COUNTA) to produce the final result.
- Click ENTER.
- In conclusion, we have successfully calculated the percentage of completion in Excel within a blink of an eye.
Comparing this method with the first method (method 1), the main difference here is we can define the specific word (Complete) with the help of the COUNTIF function, on the other hand, the COUNTA function calculates with non-blank cells only.
Read More: How to Calculate Remaining Shelf Life Percentage in Excel
Things to Remember
- Sometimes you might get decimal values instead of percentages. No worries! Selecting cells click the “Percent Style” from the Home ribbon to get the percentage output.
Download Practice Workbook
Download this practice workbook to exercise while you are reading this article.
Conclusion
In this article, I have tried to cover all the methods to calculate the percentage of completion in Excel. Take a tour of the practice workbook and download the file to practice by yourself. I hope you find it helpful. Please inform us in the comment section about your experience.
Related Articles
- How to Calculate Error Percentage in Excel
- How to Calculate Cumulative Percentage in Excel
- How to Calculate Mean Percentage Error in Excel
- How to Calculate Percentage of Budget Spent in Excel
- How to Calculate Utilization Percentage in Excel
- How to Calculate Absenteeism Percentage in Excel
- How to Calculate Savings Percentage in Excel
- How to Calculate Productivity Percentage in Excel
- How to Calculate Variance Percentage in Excel
- How to Calculate Accuracy Percentage in Excel
- How to Calculate Grade Percentage in Excel
- How to Calculate Win-Loss Percentage in Excel
- How to Calculate SLA Percentage in Excel
<< Go Back to Percentage Formula Examples | Calculating Percentages | Calculate in Excel | Learn Excel
Get FREE Advanced Excel Exercises with Solutions!