Formula Question

Hello, I'm trying to create a formula in Sheet Summary that counts the number of "yes's" within one column based on the Month/Year of a different column. My current formula is as follows but returns "0" for a value: =COUNTIF([Month/Year]:[Month/Year], "April 2022" + COUNTIF([Action Plan Compliance]:[Action Plan Compliance], "Yes")) Can yo help me write the correct formula for this count? Thank you!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!