COUNTIFS using 2 colums

Darla Brown

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?

Paul Newcome

Try removing the quotes from around the second 12.

=IF([Tenure Months]@row>12, 12)

and from inside of your COUNTIFS

=COUNTIFS([Cardmember Status]:[Cardmember Status], "ACTIVE ACCOUNT", Tenure:Tenure, 12)

Debbie Sawyer

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

Paul Newcome

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

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

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

Paul Newcome

Try removing the quotes from around the second 12.

=IF([Tenure Months]@row>12, 12)

and from inside of your COUNTIFS

=COUNTIFS([Cardmember Status]:[Cardmember Status], "ACTIVE ACCOUNT", Tenure:Tenure, 12)

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

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

Debbie Sawyer

Well done!!

Darla Brown

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

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.

Paul Newcome

@Darla Brown Happy to help! 👍️