COUNTIFS formula help

John Stanik

Hello Smartsheet Community,

I'm trying to get a COUNTIFS formula that tallies

Column1 equals "CDB"

Column2 is not blank

Column 3 does not contain the word "Prime" OR "Early"

I've got this part:

=COUNTIFS(Column1:Column1, "CDB", Column2:Column2, <>"")

But I can't figure out how to add the OR statement for Column 3

Any help or suggestions would be much appreciated!

Best,

John

Paul Newcome

You would want something like this...

=COUNTIFS(Product:Product, "CDB", [Overall Experience Score]:[Overall Experience Score], <>"", [Event Name]:[Event Name], AND(FIND("Prime", @cell) = 0, FIND("Early", @cell) = 0))

Genevieve P.

Hi @John Stanik

Try this:

=COUNTIFS([Column1]:[Column1], "CDB", [Column2]:[Column2], <>"", [Column 3]:[Column3], AND(@cell <> "Prime", @cell <> "Early"))

Let me know if this works for you!

Cheers,

Genevieve

John Stanik

@Genevieve P.

Thank you for the response. How would I manipulate that to say Column 3 does not CONTAIN the text "Prime" or "Early".

I tried this:

=COUNTIFS(Product:Product, "CDB", [Overall Experience Score]:[Overall Experience Score], <>"", [Event Name]:[Event Name], CONTAINS(AND(@cell <> "Prime", @cell <> "Early")))

And this:

=COUNTIFS(Product:Product, "CDB", [Overall Experience Score]:[Overall Experience Score], <>"", [Event Name]:[Event Name], CONTAINS(@cell <> "Prime", @cell <> "Early"))

But no luck...

Thank you,

John

Paul Newcome

You would want something like this...

=COUNTIFS(Product:Product, "CDB", [Overall Experience Score]:[Overall Experience Score], <>"", [Event Name]:[Event Name], AND(FIND("Prime", @cell) = 0, FIND("Early", @cell) = 0))

John Stanik

@Paul Newcome

Thank you Paul!

That's perfect.

Best,

John

Genevieve P.

Thanks Paul! 🙂

Paul Newcome

@John Stanik Happy to help. 👍️

@Genevieve P. Sure thing! 🙂