COUNTIFS using 2 colums
I am trying to return a count of how many active cardholders had their cards for 12 months. I'm using this formula and it keeps returning a value of 0.
=COUNTIFS([Cardmember Status]:[Cardmember Status], "ACTIVE ACCOUNT", Tenure:Tenure, "12")
I've tried using =12 and still returns 0. What am I missing?