COUNTIFS with NOT / OR plus ISBLANK.

Hello Everyone, Hoping that someone can help me out please.

I am trying to do a COUNTIFS formula with NOT / OR plus ISBLANK function.

I was able to build where I can get count of ABC units that are NEW and are not Completed or Cancelled.
Worked: COUNTIFS([Unit Name]:[Unit Name], "ABC", [Unit Type]:[Unit Type], "NEW", [Schedule visit]:[Schedule visit], NOT(OR(@cell = "Completed", @cell = "Cancelled")))

Now I have added ISBLANK to count blank cells in [Unit at WH] column but am getting error Incorrect arrangement set!
Not working: COUNTIFS([Unit Name]:[Unit Name], "ABC", [Unit Type]:[Unit Type], "NEW", [Schedule visit]:[Schedule visit], NOT(OR(@cell = "Completed", @cell = "Cancelled")), ISBLANK([Unit at WH]:[Unit at WH])))

Any suggestions would be awesome!

Find more posts tagged with

isnotblank formula

Accepted answers

Kelly Moore

@Saj

=COUNTIFS([Unit Name]:[Unit Name], "ABC", [Unit Type]:[Unit Type], "NEW", [Schedule visit]:[Schedule visit], NOT(OR(@cell = "Completed", @cell = "Cancelled")), [Unit at WH]:[Unit at WH],@cell="")

Will this work for you?
Kelly

All comments

Kelly Moore

@Saj

=COUNTIFS([Unit Name]:[Unit Name], "ABC", [Unit Type]:[Unit Type], "NEW", [Schedule visit]:[Schedule visit], NOT(OR(@cell = "Completed", @cell = "Cancelled")), [Unit at WH]:[Unit at WH],@cell="")

Will this work for you?
Kelly

Saj

Hi Kelly,

Thanks for quick reply and that worked. :)

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.