Zend certified PHP/Magento developer

How to count if a cell contains a specific number

I am attempting to check whether column C contains a specific year. I have tried this formula with no luck. I am returning 1 when it should be 12.

I have also tried changing my compare value to 2022. Same result.

=COUNTIF(C3:C38,"*"&K3&"*")

Does anyone see what I am doing wrong?

Click link to see screenshot of example