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.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!