How to countif with children using OR



I tried to understand the other posts, but I just cant seem to get the formula to work. I want to calculate agree and strongly agree on the parent row.

=COUNTIFS([nd9jwal6othm5mt5ngxdnd9jwa8x5kxw]5:[nd9jwal6othm5mt5ngxdnd9jwa8x5kxw]9, "Agree")

Answers

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭

    In the parent row enter:

    =COUNTIF(CHILDREN(),OR(@CELL="Agree", @cell="strongly agree"))

    Is that what you're looking for?


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!