Coiuntifs Formula Help Needed

Hi!

Can anyone please assist with the correct Formula? i'm trying to count how many rows are on a sheet(Reference Sheet)

the criterea for the rows are as follows: =countifs STATUS Column is "Discharged" or "ACTIVE" , Discharged/Nonadmit Column is Greater than 05/19/2023 and Date activated column is less than 05/27/2023

I Created this Formula but its coming up unparseable. can anuyone help where im going wrong?

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

Find more posts tagged with

Accepted answers

Razetto

@Ymandel See if this version works:

=COUNTIFS([Discharged Date]:[Discharged Date], >DATE(2023, 5, 26), [Date Activated]:[Date Activated], <=(DATE(2023, 6, 2)), [Status]:[Status], OR(@cell = "Active", @cell = "Discharged"))

All comments

Razetto

@Ymandel See if this version works:

=COUNTIFS([Discharged Date]:[Discharged Date], >DATE(2023, 5, 26), [Date Activated]:[Date Activated], <=(DATE(2023, 6, 2)), [Status]:[Status], OR(@cell = "Active", @cell = "Discharged"))

Ymandel

Yes! it did. i added the @cell and its working well. thank you so much!

Ymandel

So now this formula works well

=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?

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.