COUNTIFS with month and year

jenniferrdz

The data that I have is on the Date:Date column. I want the formula to return the amount of cells that meet the month and year criteria. I have the following formula and I'm not sure what's wrong but it gives the #unparseable error. I have tried many different formulas from other posts but can't get it right.

=COUNTIFS(Date:Date, IFERROR(MONTH(@cell), 0) = 6), IFERROR(YEAR(@cell), 0)=2022))

Thanks!

Dan W

Hope this helps

=COUNTIFS(Date:Date, IFERROR(MONTH(@cell), 0) = 6, Date:Date, IFERROR(YEAR(@cell), 0) = 2022)

Samuel Mueller

You have an extra parentheses

=COUNTIFS(Date:Date, IFERROR(MONTH(@cell), 0) = 6, Date:Date, IFERROR(YEAR(@cell), 0)=2022)

Edit: good call @Dan W - also need the criteria range again.

Dan W

Hope this helps

=COUNTIFS(Date:Date, IFERROR(MONTH(@cell), 0) = 6, Date:Date, IFERROR(YEAR(@cell), 0) = 2022)