countifs formula to sum not blank dates

Kelly M
Kelly M
edited 12/09/19 in Smartsheet Basics

Hello ~ I'm new to the community and working with the COUNTIFS formula. Help would be much appreciated if you can see the error of my ways. What I want to do seems simple - I have a "Date Completed" column, defined as a Date type, and want to count how many times it's been entered in the column.  I saw a thread earlier that addressed a similar topic, but I've so far been unable to get it to work.  Here's the formula I'm working with: 

=COUNTIFS([Date Completed]:[Date Completed], IFERROR(YEAR(@cell), 0) >= 2019)  

I'd like it to be more generic, using a not isempty, but so far haven't been able to get it to work.  The formula is expecting a #DATE EXPECTED (presumably since the column is a Date type) - is there a way to do this?

Thank you

Tags:

Comments