COUNTIF or COUNTIFS formula for a date column, criteria based off MONTH and YEAR


I am trying to total the number of completed submissions on my Ankeny Repair spreadsheet based off of a specific month from a specific year. Range 4 is the column with the completed dates. My current formula is this...

=COUNTIFS(MONTH({Ankeny Repair Range 4} = 1) AND (YEAR({Ankeny Repair Range 4}, =2020)))

The error message I get is this...


Honestly I've tried this formula so many different ways I don't know what is the correct function to use.I do know that I am missing the IFERROR() part as welll since some of the dates are blank within the range.

Any help is very much appreciated - thank you!

Best Answer



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!