Count IFS and NOT(IsBlank

Good morning!

I am attempting to use a sheet to count instances on another sheet and keep getting an Incorrect Argument error on the rows that should be counted.

I am counting the number of jobs with a particular type where one column is blank and another is not blank.

So count by Job Type, if Engineering Completion Date is blank, and Division Name is not blank (this is to weed out the additional rows on the sheet with no data in them). I have attached a screenshot below. For other branches I can simply put Division is equal to "X" but this branch has two locations so I thought it may be easier to just use "Not Blank".

Thanks for your help!

Find more posts tagged with

Accepted answers

Paul Newcome

It looks like you misplaced a parenthesis. Take one from the end and move it to after the NOT(ISBLANK(@cell).

Right now you are closing out the ISBLANK function, but then everything after that is part of the NOT function because it isn't closed out.

All comments

Paul Newcome

It looks like you misplaced a parenthesis. Take one from the end and move it to after the NOT(ISBLANK(@cell).

Right now you are closing out the ISBLANK function, but then everything after that is part of the NOT function because it isn't closed out.

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.