Formula for counting in two separate columns


I'm trying to count the number of "yes" responses from one column using the range of a second column titled "Month/Year". I entered the following formula but the value returned was "0".

=COUNTIF([Month/Year]:[Month/Year], "April 2022" + COUNTIF([Action Plan Compliance]:[Action Plan Compliance], "Yes"))

I would like to use a value within the Month/Year column rather than adding the beginning and ending row numbers.

Any help is appreciated!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!