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?

Best Answer

Answers

  • Debbie Sawyer
    Debbie Sawyer ✭✭✭✭✭

    Do you have any that match? Maybe it is returning the right answer?

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    What is in the Tenure column and how is that data populated?

    thinkspi.com

  • Darla Brown
    Darla Brown ✭✭✭✭✭✭

    The Tenure column is a formula. =IF([Tenure Months]@row>12, "12". I know there are at least a couple hundred 12's.

  • Debbie Sawyer
    Debbie Sawyer ✭✭✭✭✭

    Any chance you could grab a screen shot? It doesn't look like there is anything wrong with the formula.

  • Debbie Sawyer
    Debbie Sawyer ✭✭✭✭✭

    Yes I agree with @Paul Newcome however on testing a text/number column within a countifs you could declare criteria as =12 or "12" or 12 and they should all work!

  • Darla Brown
    Darla Brown ✭✭✭✭✭✭

    That worked Paul! I removed both quotes and it returned a correct number. Thanks!

  • Debbie Sawyer
    Debbie Sawyer ✭✭✭✭✭

    Well done!!

  • Darla Brown
    Darla Brown ✭✭✭✭✭✭

    I do have an =12 in the formula. Didn't have it before. That may have been it all along! 😂

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    @Debbie Sawyer Yes. I agree it SHOULD work, but sometimes it doesn't (you know how Smartsheet can get sometimes). Since that is something very easy to change, it is one of the first things I give a try so that I can go ahead and rule it out if that isn't it.

    thinkspi.com

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    @Darla Brown Happy to help! 👍️

    thinkspi.com