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

Find more posts tagged with

Accepted answers

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))

All comments

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! 🙂

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.