COUNTIF using multiple criteria


I am trying (what I thought was a simple formula) to countif using multiple criteria. I have a drop-down column. I want to calculate the number of "yes" and number of "Maybe - Depending on caseload" for the CHILDREN.

I am using: =COUNTIF(CHILDREN(), "Yes", [CHILDREN(), "Maybe - Depending on my caseload"]) but it doesn't work. Where is my error? When I remove the second criteria it calculates the "yes" perfectly. I am certain this is a error in how I put in the second criteria but I'm not seeing it.

Thank you for any help you all can provide!

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!