OR Function Help Needed

I Created this Formula Below:

=COUNTIFS({Discharged Date}, >(DATE(2023, 5, 26)), {Date Activated}, <(DATE(2023, 6, 2)), {Status}, OR(@cell = "ACTIVE", @cell = "DISCHARGED"))

However, i need to add in an OR function to the first 2 phrases.

it should count if {discharged date} is greater thatn 5.26.23 or Blank, AND {Date activated} us Less than 6.2.23 or Blank, AND {Status is Active or Discharged"

Can you help me with the correct formula?

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

It would be the same way you have the OR function for the last range/criteria set. Double quotes can be used for "blank"

@cell = ""

Ymandel

I tried it but its coming up invalid Data Type. this is the formula im trying

=COUNTIFS(OR({Discharged Date}, >(DATE(2023, 5, 26)), @cell = ""), OR({Date Activated}, <(DATE(2023, 6, 2)), @cell = ""), {Status}, OR(@cell = "ACTIVE", @cell = "DISCHARGED"))

please let me know where im going wrong

Paul Newcome

That's not the same syntax as the last range/criteria set though.

You entered

OR({Range}, criteria, criteria)

The last range/criteria set is entered as

{Range}, OR(criteria, criteria)

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.