Countifs and NOT(ISBLANK)

Hi, I'm hoping someone can point me in the correct direction.

I'm trying to get a Count of the amount of unit of a specified category if they are not yet assigned.

Basically, I have Column "STOCK" that I want to count what is assigned in box SEARCH201 if "ASSIGNED" is empty. This is what I have so far:

=COUNTIFS(STOCK1:STOCK200, SEARCH201, NOT(ISBLANK(ASSIGNED1:ASSIGNED200)))

But I get: incorrect argument

Thanks for any help you can provide!

Find more posts tagged with

Formulas

Accepted answers

All comments

parulmishra

Hi @Daniel Damico

we need to use @cell to check what's blank, something like this

=COUNTIFS(STOCK1:STOCK200, SEARCH201,ASSIGNED1:ASSIGNED200, NOT(ISBLANK(@cell)))

This could give you more help https://help.smartsheet.com/articles/2476491-create-efficient-formulas-with-at-cell

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.