COUNTIFS one OR another criteria

Hello, I am trying to find the number of cells in a column that are blank OR do not contain a specific word. I believe the way that I have it right now would be AND rather than OR. Any suggestions?

Need: If Accounting column is checked and Bio Status is blank OR does not contain "Posted"

I'm currently getting 1 as the total, but it should be 2

=COUNTIFS(Attorney:Attorney, 1, [Bio Status]:[Bio Status], "") + COUNTIFS(Attorney:Attorney, 1, [Bio Status]:[Bio Status], NOT(CONTAINS("Posted", [Bio Status]:[Bio Status])))

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

Try somethign like this...

=COUNTIFS(Attorney:Attorney, 1, [Bio Status]:[Bio Status], OR(@cell = "", @cell <> "Posted"))

All comments

Paul Newcome

Try somethign like this...

=COUNTIFS(Attorney:Attorney, 1, [Bio Status]:[Bio Status], OR(@cell = "", @cell <> "Posted"))

Tiffany Scaramucci

It worked! Thank you so much!

Paul Newcome

Happy to help. 👍️

Tiffany Scaramucci

Can I add multiple "is not equal to" items to this?

=COUNTIFS(Attorney:Attorney, 1, [Bio Status]:[Bio Status], OR(@cell = "", @cell <> "Posted", @cell <> "N/A"))

Paul Newcome

Yes so long as you follow the same pattern within the OR function.

Stacey Carrasco

@Paul Newcome How can I count using 2 columns

I have one column named Course term with different values and I'm trying to search for value "20SU" and then I have another column w/ employee names that I want to count if the employee name appears for 20SU.

So I'm trying to come up with the COUNTIFS formula that says search the term column for all 20SU and then search the employee name and count how many times the employee name is related to the 20SU term.

I'm stumped do I use a FIND

I was thinking something like: =COUNTIFS({Course term}, FIND("20SU", @cell), {Employee name}, FIND("Name", @cell) > 0) I'm missing something here.

Paul Newcome

@Stacey Carrasco You just forgot the "> 0" bit after the first FIND function is all.

Stacey Carrasco

@Paul Newcome ugh that was it!! oh geesh

Thanks for catching that!!

Paul Newcome

Happy to help. 👍️

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.