I have tasks list which has which has its completion percentage in Column G. These tasks have parent tasks, sub parent tasks and child tasks. They are represented as MP(Master Parent), SP(Sub Parent) and C(Child) in column A. Now I want to calculate
1) Sum of %age of All tasks with completion >0% and <100% of SP(Sub parent)
2) Count of All tasks with completion >0% and <100% of SP(Sub parent)
How can i do this, please help, attached is sheet
Bookmarks