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
-
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
-
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")
https://www.linkedin.com/in/zchrispalmer/
-
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))
-
Leibel, that worked! Thanks so much for the help!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!