Count Children Rows w/ Specific Statuses


I have a Status column that has the following drop-down items - To Do, In Progress, Done, and Future Work Cycle Task. I want to sum the # of child rows with the status of To Do or In Progress.

I tried =COUNTIFS(CHILDREN(), "To Do", CHILDREN(), "In Progress") and it doesn't work; however, when tried just =COUNTIFS(CHILDREN(), "To Do") it worked and tried =COUNTIFS(CHILDREN(), "In Progress") it worked. I just need these numbers to add together :(

Best Answer