This is an Excel 2010 problem. I know that in later Excel versions there is a MAXWENN function and a MAXWENNS function but I cannot use those because in this company there is only Excel 2010.
I have a small table of tasks in different hierarchical levels (objective, milestone, task, subtask). Now I estimate for all Tasks of any level that have no children how many more days it will take me to complete the task (Restdauer [Tage]). For every task that has children I want to estimate the completion time as the max over the completion times of all children by the following formula:
thanks! I understand the problem with AND now. I changed the operator to *. However, if still does not work in my sheet. In my sheet, the Max Column and the Res [Tage] Column are the same column. Can this be the reason?