Countif the Year 2021 on a Column Returns #invalid data type or zero.

heyjay

https://app.smartsheet.com/sheets/xXvWq9JrWMjRXGHv7jcV4Q4GF45wJWc4C32GcHw1

MCorbin

Try this:

=COUNTIF(Date1:Date11, YEAR(@cell) = 2021)

MCorbin

Try this:

=COUNTIF(Date1:Date11, YEAR(@cell) = 2021)

heyjay

https://community.smartsheet.com/discussion/comment/305949#Comment_305949

Thank you, it worked. didnt know it needs @cell code. This is my first time seeing this one. Need to read the documentation.