COUNTIFS And OR

The formula below works, but I have a situation where I want to count when two different attorneys are listed in the Attorney field.

=COUNTIFS(Attorney:Attorney, ="Attorney1", [Contract Status]:[Contract Status], OR(@cell = "Customer Legal Review", @cell = "Pending PAC", @cell = "Pending SRTC", @cell = "Sent for Signatures", @cell = "WD Legal Review", @cell = "Waiting for Requestor Response"))

Can someone please assist? Thank you.

Find more posts tagged with

Formulas

Accepted answers

All comments

Bassam Khalil

Hi @Shannon Heward

Hope you are fine, please try the following formula this is for example if the Attorney cell contains ( Attorney1 or Attorney2)

=COUNTIFS(Attorney:Attorney, OR(CONTAINS("Attorney1", @cell), CONTAINS("Attorney2", @cell)), [Contract Status]:[Contract Status], OR(@cell = "Customer Legal Review", @cell = "Pending PAC", @cell = "Pending SRTC", @cell = "Sent for Signatures", @cell = "WD Legal Review", @cell = "Waiting for Requestor Response"))

Shannon Heward

Thank you for responding. Unfortunately, this isn't working the way I need. I'm wanting the count returned when it contains both attorneys [by name but referenced here as Attorney1 and Attorney2 here] and meets one of the contract status criteria. Can you please assist? Thank you.

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.