Countifs Formula - Month & Year

jelfner

I have used AI and still getting an #INVALID DATA TYPE" error when I try to create this formula. I am trying to count if the "Renewal Month" column is January and the "Renewal Year" column is 2025. Below is the formula I am using. If it makes a difference, these two columns are populated by a formula to get the month and year. Any idea what needs corrected to get the formula to work? Thank you!!!

=COUNTIFS([Renewal Month]:[Renewal Month], "January", [Renewal Year]:[Renewal Year], 2025)

jcaguioa

Hello. Did you try putting the year in quotations as well? i.e "2025"

I made a mock up and the syntax is correct. I just put the year in quotes and it seems to work.

jelfner

Hi - Thanks for the quick answer! I have tried with both quotations and without, and I get the error with both versions. I just tried this again, and still getting an error. Any other thoughts?

=COUNTIFS([Renewal Month]:[Renewal Month], "January", [Renewal Year]:[Renewal Year], "2025")

jcaguioa

Also, it seems the brackets are not present in the formula I used.

jelfner

Hi - Could you cut/paste the formula that is working for you please?