Microsoft Excel Task 02: Display Overall Status in one column when All Tasks are Completed in Excel

Microsoft Excel Task 02:  Display Overall Status in one column when All Tasks are Completed in Excel ?

You can achieve this in Excel by adding a formula in the 4th column that checks if all statuses in the second column are "Completed." If they are, it displays "All Completed"; otherwise, it shows "In Process."

Steps:

1. Setup Your Table:
• Column A: Percentage (e.g., 10%, 20%, etc.)
• Column B: Status (e.g., Completed, Inprocess, Cancelled, Not Start)
• Column C: Total Percentage
• Column D: Overall Status
2. Formula in Column D: In the cell where you want the overall status (e.g., D1), use this formula:

   =IF(COUNTA(B:B) = COUNTIF(B:B, "Completed"), "All Completed", "In Process")
   

   • Explanation:
     • COUNTA(B:B) counts all non-empty cells in the Status column.
     • COUNTIF(B:B, "Completed") counts cells with the status "Completed".
     • If the two counts match, all tasks are completed; otherwise, tasks are still in progress.
3. Dynamic Updates:
   • As you update the statuses in Column B, the formula in Column D will automatically reflect the correct overall status.

---

Example Table:

Percentage	Status	Total Percentage	Overall Status
10%	Completed
20%	Inprocess		In Process
30%	Completed
15%	Completed	55%

Once all rows in Status are marked as "Completed," Overall Status will change to "All Completed".

---

Thanks for reading, if it helpful for you then like and comment :)