CountIF Month AND Year

raymond.j.riosiii94806 · 12/17/19

Trying to perform a CountIF AND function where a cell counts the reference cell containing a Specific Month and Specific Year. The following formula is returning unparsable error:

=COUNTIF({EHS Visit Tracker - DoV}, IFERROR(MONTH(@cell), 0) = 1), IFERROR(YEAR(@cell),0)=2020)

Can you help?

Paul Newcome · 12/18/19

It is just a misplaced parenthesis. Try this one...

=COUNTIF({EHS Visit Tracker - DoV}, AND(IFERROR(MONTH(@cell), 0) = 1, IFERROR(YEAR(@cell),0)=2020))

Paul Newcome · 12/19/19

You have a misplaced parenthesis, and the AND function is not needed in this case. Also, to include multiple ranges, you need to switch over to a COUNTIFS (with the "S" on the end) and use the following syntax...

=COUNTIFS(range_1, crieria_1, range_2, criteria_2, ....................................)

=COUNTIF({EHS Visit Tracker - Provider}, "AB", {EHS Visit Tracker - Date Range}, IFERROR(YEAR(@cell), 0) = 2020)

L_123 · 12/18/19

=COUNTIF({EHS Visit Tracker - DoV}, and(IFERROR(MONTH(@cell), 0) = 1), IFERROR(YEAR(@cell),0)=2020)

Use the AND function when you have multiple criteria

raymond.j.riosiii94806 · 12/18/19

I tried that and I get an #Incorrect Argument Set error...

Paul Newcome · 12/18/19

It is just a misplaced parenthesis. Try this one...

=COUNTIF({EHS Visit Tracker - DoV}, AND(IFERROR(MONTH(@cell), 0) = 1, IFERROR(YEAR(@cell),0)=2020))

raymond.j.riosiii94806 · 12/18/19

Worked like a charm, thank you Paul!

raymond.j.riosiii94806 · 12/18/19

What am I doing wrong with this version:

=COUNTIF({EHS Visit Tracker - Provider}, "AB"), AND(IFERROR(YEAR(@cell), 0) = 2020))

Paul Newcome · 12/19/19

You have a misplaced parenthesis, and the AND function is not needed in this case. Also, to include multiple ranges, you need to switch over to a COUNTIFS (with the "S" on the end) and use the following syntax...

=COUNTIFS(range_1, crieria_1, range_2, criteria_2, ....................................)

=COUNTIF({EHS Visit Tracker - Provider}, "AB", {EHS Visit Tracker - Date Range}, IFERROR(YEAR(@cell), 0) = 2020)

raymond.j.riosiii94806 · 12/19/19

Awesome, thank you again!

Paul Newcome · 12/19/19

Happy to help! 👍️

Please don't forget to mark an answer as the "Accepted Answer". That way people looking for a similar solution or people looking for unanswered posts to help with know that there is a solution provided in the thread.

AtomicDancer · 02/17/25

What am I doing wrong with this version?
=COUNTIF({Returns - Created}, (IFERROR(MONTH(@cell), 0) = 1), IFERROR(year(@Cell),0)=2025))

I've also tried

=COUNTIF({Returns - Created}, AND(IFERROR(MONTH(@cell), 0) = 1), IFERROR(year(@Cell),0)=2025))

It keeps returning #UNPARSEABLE

Thank you

Paul Newcome · 02/17/25

@AtomicDancer Your second one is closest. "@cell" is case sensitive and should be all lowercase.

AtomicDancer · 02/17/25

@Paul Newcome

Thank you for the tip about @cell being case-sensitive.

Even with changing that, I am still getting #UNPARSEABLE

=COUNTIF({Returns - Created}, AND(IFERROR(MONTH(@cell), 0) = 1), IFERROR(year(@cell),0)=2025))

Both halves work individually, but not when combined.

=COUNTIF({Returns - Created}, IFERROR(MONTH(@cell), 0) = 1)

=COUNTIF({Returns - Created}, IFERROR(year(@cell),0)=2025)

Paul Newcome · 02/17/25

Ah. Sorry for missing it on the first comment. The closing parenthesis after the 1 also needs to be removed.

Formulas and Functions

Formulas and Functions

CountIF Month AND Year

Best Answers

Answers

Help Article Resources

Quick Links

Categories

Trending in Formulas and Functions

Finding if a date falls in a range in a referenced sheet

CountIF contains name from a contact list help needed

Formula for averaging days