Formula for COUNTIF and ISBLANK (Need Help)

Lacey C

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})))

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))

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