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.
Download Practice Workbook
Download this practice workbook to exercise while you are reading this article.
3 Quick Methods to Calculate Percentage of Completion in Excel
In the following, I have explained 3 quick and simple tricks to calculate percentage of completion in Excel. Stay tuned!
Suppose we have a dataset with some Dates, Tasks needed to complete 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 applying the COUNTA function. The COUNTA function will count blank cells in a range in this list.
- First, select a cell (F5) and apply the following formula down-
Here, COUNTA(D5:D12) counts the number 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.
Read More: Calculate Percentage in Excel VBA (Involving Macro, UDF, and UserForm)
- How to Make Cumulative Percentage Polygon in Excel
- Show One Number as a Percentage of Another in Excel
- Calculate Percentage Based on Conditional Formatting (6 Ways)
- How to Use IF and Percentage Formula in Excel (2 Easy Ways)
- Apply Percentage Formula in Excel for Marksheet (7 Applications)
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. Because in this method, I will show you an easy trick to calculate 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 obtained marks.
- Presently, we will determine the total obtained mark of each student. To do that, select a cell (G8) and write the following formula down-
- Gently, press ENTER and drag the “Fill Handle” down to fill all the cells.
- Next, choose another cell (H8) and apply the below formula-
- 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.
Read More: Calculate Percentage Using Absolute Cell Reference in Excel (4 Methods)
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-
- To start with, choose a cell (F5) and apply the formula below-
- 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 Apply Percentage Formula for Multiple Cells in Excel (5 Methods)
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.
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. We, the Exceldemy team, are always responsive to your queries. Stay tuned and keep learning.
- Calculate Productivity Percentage in Excel (3 Useful Cases)
- How to Calculate ROI Percentage in Excel (6 Easy Ways)
- Calculate Total Percentage from Multiple Percentages in Excel
- How to Calculate Savings Percentage in Excel (3 Easy Ways)
- Calculate Error Percentage in Excel (3 Easy Methods)
- How to Calculate SLA Percentage in Excel (with Quick Steps)
- Calculate Percentage of Filled Cells in Excel (7 Easy Ways)