Countif the Year 2021 on a Column Returns #invalid data type or zero.
Options
Best Answer
-
Try this:
=COUNTIF(Date1:Date11, YEAR(@cell) = 2021)
Answers
-
Try this:
=COUNTIF(Date1:Date11, YEAR(@cell) = 2021)
-
Thank you, it worked. didnt know it needs @cell code. This is my first time seeing this one. Need to read the documentation.
...
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!