Hey Community -
I am having an issue trying to use the COUNTIF formula. In this use case, I basically have a formula in the first column to show if start and end dates match with other columns in the sheet.
All I want to do is count the number of "Yes" cells, but when I try to use the COUNTIF formula, I get an #INVALID DATA TYPE. Any ideas on how to fix? The column type is "text," so I wonder why it is not pulling correctly.

