COUNTIF Function

Mindy Schneider

This seems so easy but mine won't work no matter what I try. I am trying to obtain a percentage of "yes" answers for the CHILDREN.

I want the calculation in my PARENT Row but to only calculate the CHILDREN.

All my attempts show up as this. What am I doing wrong??

Paul Newcome

If you are also wanting to include blanks in the overall calculation...

=COUNTIFS(CHILDREN(), "Yes") / COUNTIFS(CHILDREN(), OR(@cell = "Yes", @cell <> "Yes"))

If you are only including Yes and No in the overall calculation and excluding blanks, then this should work:

=COUNTIFS(CHILDREN(), "Yes") / COUNTIFS(CHILDREN(), OR(@cell = "Yes", @cell = "No"))

Paul Newcome

If you are also wanting to include blanks in the overall calculation...

=COUNTIFS(CHILDREN(), "Yes") / COUNTIFS(CHILDREN(), OR(@cell = "Yes", @cell <> "Yes"))

If you are only including Yes and No in the overall calculation and excluding blanks, then this should work:

=COUNTIFS(CHILDREN(), "Yes") / COUNTIFS(CHILDREN(), OR(@cell = "Yes", @cell = "No"))

Mindy Schneider

You are so smart! Thank you Thank You Thank You!! I appreciate you Paul Newcome!

Paul Newcome

Hahaha. Happy to help! 👍️