CountIF Month AND Year

raymond.j.riosiii94806

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

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

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

=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

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

Paul Newcome

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

Worked like a charm, thank you Paul!

raymond.j.riosiii94806

What am I doing wrong with this version:

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

Paul Newcome

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

Awesome, thank you again!

Paul Newcome

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.