I have created 10 rows of project tasks where each row/task has a Data Validation "list" criteria drop down box with the option of using one of the following three choices: 1) Pending Start, 2) In Progress, or 3) Complete.
I have also created an overall status cell above the 10 tasks to show the overall summary status of the entire task list in question. The intent/objective is for this summary status cell to update automatically based on the combination of each of the 10 task statuses. My criteria is below:
* If ALL 10 rows have a status of "Pending Start", then the summary status cell should show "Pending Start"
* If ALL 10 rows have a status of "Complete", then the summary status cell should show "Complete"
* Otherwise, if there is any other combination of the three statuses across all 10 tasks, the summary status cell should show, "In Progress".)
I've tried different formulas with different functions and the formula below is the closest I've come to making it work. Unfortunately I can't quite make it work.
=IF(COUNTIF($G$10:$G$19,"Complete"),"Complete",IF(COUNTIF($G$10:$G$19,"Pending_Start"),"Pending_Start","In Progress"))
Any help you can provide is very much appreciated. Thank you!
Bookmarks