COUNTIF or COUNTIFS formula for a date column, criteria based off MONTH and YEAR

Sue Hill · 04/20/21

says #

unparseable under the formula.

Paul Newcome · 04/20/21

@Sue Hill You are missing the comma after the first range.

Sue Hill · 04/21/21

Thank you!

Also, is there a way to add a 2nd item in the Review Status , like "Resolved" , "Closed" ?

Paul Newcome · 04/21/21

Yes. You would do the regular range

=COUNTIFS({Range},

Then the criteria will be an OR function with @cell references.

=COUNTIFS({Range}, OR(@cell = "This", @cell = "That"), .................

Sue Hill · 04/21/21

YES! got it!

Paul Newcome · 04/21/21

Great! Happy to help. 👍️

Sue Hill · 04/22/21

How to count blanks similarly ... Review Status column has "Pending Resolution" or "" as blanks...

=COUNTIFS({Review Status}, OR(@cell = "Pending Resolution", (@cell = ""), {Year}, @cell = 2021, {Month Number}, @cell = 1))

Paul Newcome · 04/23/21

Too many parenthesis. Try this one...

=COUNTIFS({Review Status}, OR(@cell = "Pending Resolution", @cell = ""), {Year}, @cell = 2021, {Month Number}, @cell = 1)

Answers