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

heyjay ✭✭✭✭✭

09/23/21 in Formulas and Functions

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

...

Tags:

• Calendar View
• Formulas

0 · Share on FacebookShare on Twitter

Best Answer

• 

  MCorbin Overachievers Alumni

  09/23/21 Answer ✓

  Try this:

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

  1 · Share on FacebookShare on Twitter

Answers

• 

  MCorbin Overachievers Alumni

  09/23/21 Answer ✓

  Try this:

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

  1 · Share on FacebookShare on Twitter
• 

  heyjay ✭✭✭✭✭

  09/24/21

  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.

  ...

  0 · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list