Function for Counting Children of Parent Rows
Hi - I have been wrestling with this function and need some help.
Here is the data:
In my sheet summary, I am trying to enter a function to count the children who answer yes. I have tried it a bunch of ways, and it will count if I only ask it to count children, or if I only ask it to count the yes answers, but I cannot get them together.
=COUNTIF(CHILDREN([Month/Year - MRN]1, [Documented Flush q12?]:[Documented Flush q12?],"Y"))
Help Article Resources
Check out the Formula Handbook template!