Count only child rows that have "Complete" in 3 columns
Hi I am trying to count the number of child rows that have "Complete" in 3 different columns. Here is my current formula:
=COUNTIFS((CHILDREN)1, [HS Germ]:[HS Germ], "Complete", [HS Pave]:[HS Pave], "Complete", [Classroom]:[Classroom], "Complete")
I keep getting "UNPARSEABLE". Any suggestions?
Help Article Resources
Check out the Formula Handbook template!