COUNTIFS using different sheet for range and month for criteria


I am attempting to get this formula in my tracker sheet to work to count all the instances in the reference sheet where a certain month in the date column occurs and the answer to a question in another column is no. This is the formula I have come up with and I know it's wrong but all of the fixes I have attempted have not worked. Currently it returns a 0 but I know that is incorrect.

=COUNTIFS({Wave 2 Wrap Up Date}, =12, {Wave 2 Wrap Up Close}, "No")

**Note: The ranges are from the same sheet, just different reference names**

Thanks in advance!


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!