How to countif with children using OR
Options
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
-
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
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!