COUNTIFS returning 0

Rebekah Valdez-Pound

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

Kelly Moore

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.

Kelly Moore

Hey

try this

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

Rebekah Valdez-Pound

@KDM I am getting the infamous #UNPARSEABLE error with that formula

Kelly Moore

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.

Rebekah Valdez-Pound

@KDM

Eureka- It worked!! Thank you so much for your help!

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