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.

**Table of Contents**hide

## 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.

**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 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)**

**Similar Readings**

**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.

**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.

**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-

**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 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.

## 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. We, the __Exceldemy__** **team, are always responsive to your queries. Stay tuned and keep learning.

## Related Articles

**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)**