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

Best Answer

  • Leibel S
    Leibel S ✭✭✭✭✭✭
    Answer ✓

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

Answers

  • Mr. Chris
    Mr. Chris ✭✭✭✭✭

    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
    Leibel S ✭✭✭✭✭✭
    Answer ✓

    @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
    Lacey C ✭✭

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!