Formula for COUNTIF and ISBLANK (Need Help)

I'm trying to find the total amount of buyers we have not released to build for the month of January and I'm getting stuck. The criteria that needs to be met are as following:

Company must = AHI

Status must = ACTIVE

Buyer Desire Month must = January

Contingency column must be blank

Buyer Name cannot= "Model", "Lot Purchase", "Model"

=COUNTIFS(AND({Constat Range COMPANY}, "AHI", {Constat Range STATUS}, "ACTIVE", {Constat Range BUYER DESIRE MONTH}, "January", ISBLANK({Constat CONTINGENT})))

Find more posts tagged with

Accepted answers

Leibel S

@Lacey C

You don't need the AND function at all. Then ISBLANK needs to be part of the criteria using @cell.

See below how:

=COUNTIFS({Constat Range COMPANY}, "AHI", {Constat Range STATUS}, "ACTIVE", {Constat Range BUYER DESIRE MONTH}, "January", {Constat CONTINGENT}, ISBLANK(@cell))

All comments

=Chris Palmer

Hi @Lacey C,

Something like this may work or be refined:

=COUNTIFS({Constat Range COMPANY}, "AHI", {Constat Range STATUS}, "ACTIVE", {Constat Range BUYER DESIRE MONTH}, "January", {Constat CONTINGENT}, "", [Buyer Name]:[Buyer Name], "<>Model", [Buyer Name]:[Buyer Name], "<>Lot Purchase")

Leibel S

@Lacey C

You don't need the AND function at all. Then ISBLANK needs to be part of the criteria using @cell.

See below how:

=COUNTIFS({Constat Range COMPANY}, "AHI", {Constat Range STATUS}, "ACTIVE", {Constat Range BUYER DESIRE MONTH}, "January", {Constat CONTINGENT}, ISBLANK(@cell))

Lacey C

Leibel, that worked! Thanks so much for the help!

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.