Comments not blank for current year

Amy Swan

I'm getting an incorrect argument set on this sheet summary formula. I'm capturing the count of non-blank comments for the current year. Can you tell me where I went wrong? I tried changing to count if and same error.

=COUNTIFS(Comments:Comments, NOT(ISBLANK(@cell), Created:Created, IFERROR(YEAR(@cell, 0) = YEAR(TODAY()))))

Kelly Moore

Hey @Amy Swan

When using a function within a COUNTIFS, the function needs to be closed off as part of the criteria. The closing parentheses were placed at the end of the COUNTIFS instead.

=COUNTIFS(Comments:Comments, NOT(ISBLANK(@cell)), Created:Created, IFERROR(YEAR(@cell), 0) = YEAR(TODAY()))

Will this work for you?

Kelly

Kelly Moore

Hey @Amy Swan

When using a function within a COUNTIFS, the function needs to be closed off as part of the criteria. The closing parentheses were placed at the end of the COUNTIFS instead.

=COUNTIFS(Comments:Comments, NOT(ISBLANK(@cell)), Created:Created, IFERROR(YEAR(@cell), 0) = YEAR(TODAY()))

Will this work for you?

Kelly

Amy Swan

Bless you Kelli Moore- That worked!