COUNTIFS returning 0

I am having an issue with the formula below. I am attempting to get the count where the year of {Conv Rec 020} equals the cell "2020" and the month of {Conv Rec 020} equals 1 (aka: January). I have quoted the 1 and get the same results.

The formula is returning "0"... any thoughts to return the correct values? It should be 57.

=COUNTIFS(IFERROR(YEAR({Conv Rec 020}), 0), =Year1, IFERROR(MONTH({Conv Rec 020}), 0), 1)

{Conv Rec 020} is a DATE column from the referenced sheet

Year1 = 2020

Best Answer

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    Answer ✓

    Two curly brackets are out of place. Add a curly bracket immediately after the Countif parenthesis. Remove curly bracket ahead of @cell. I had caught these errors last night and corrected but somehow the editing didn't 'stick' when I posted.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!