I have the Year and Month on a sheet. How can I have the summary look at both to count?

MelanieJohn

I would like to create a summary if the month is Sept AND the year is 2024 to count. I have found that I can use the and but keep getting an error message

This is the Formula I have in the Summary that is coming up #Unparseable

=COUNTIFS([Next Renewal Year]:[Next Renewal Year], "2024") AND(([Next Renewal Month]], "Sept")

Leibel S

@MelanieJohn

Each rule gets its own range and criteria. Below is how you would do it in this case:

=COUNTIFS([Next Renewal Year]:[Next Renewal Year], "2024", [Next Renewal Month]:[Next Renewal Month], "Sept")

Leibel S

@MelanieJohn

Each rule gets its own range and criteria. Below is how you would do it in this case:

=COUNTIFS([Next Renewal Year]:[Next Renewal Year], "2024", [Next Renewal Month]:[Next Renewal Month], "Sept")

MelanieJohn

Thank you. I figured it was something stupid that I was missing. That worked.