Microsoft Excel Task 01: How to Calculate Total Percentage of "Completed" Tasks in Excel

Microsoft Excel Task 01: How to Calculate Total Percentage of "Completed" Tasks in Excel ?

Yes, it's possible to achieve this in Excel using formulas and conditional summation. Here's how you can set it up:

Steps to Calculate Total Percentage of "Completed" Tasks:

1. Setup Columns:

• Column A: Percentage (e.g., 10%, 20%, etc.)
• Column B: Status (e.g., Inprocess, Completed, Cancelled, Not start)
• Column C: Total Percentage

2. Formula for Total Percentage:

• In the cell where you want the Total Percentage, use the SUMIF function to sum only the percentages where the status is "Completed".
• Example formula:

  =SUMIF(B:B, "Completed", A:A)
  

• Explanation:
  • B:B is the column for the status.
  • "Completed" specifies the status to filter.
  • A:A is the column for the percentages.

3. Dynamic Updates:

• Whenever a status changes to "Completed", the formula will automatically update the total percentage.

Example Table:

Percentage	Status	Total Percentage
10%	Completed
20%	Inprocess
30%	Completed
15%	Not start	40%

Here, the total percentage (40%) is the sum of percentages for rows where the status is "Completed."

---

Additional Tips:

• Ensure Numeric Values: Ensure that percentages in Column A are formatted as numbers with percentage format.
• Case-Insensitive Matching: The SUMIF function is case-insensitive by default.
• Dynamic Ranges: If the data grows dynamically, consider limiting the range (e.g., A1:A100) for better performance.