COUNTIF formula with ISBLANK help
Hello! I keep getting confused with these countif and blank formulas :( would appreciate some guidance. I am looking to create a formula that pulls from another sheet that counts all the sites that have an assigned number BUT has the "inactive status" as blank.
Essentially only counting the active sites with an assigned number.
=COUNTIF({Site Number}, {Master Data | Inactive Status}, ISBLANK, <>"")
I know it's wrong especially after the ISBLANK but I'm not sure what to add after that. Thanks in advance!
Answers
-
Hello - would this work?
=COUNTIF({Site Number}, {Master Data | Inactive Status} <> "")
Thanks -Peggy
-
It's still counting the ones that have an inactive status :(
=COUNTIF({Site Number}, {Master Data | Inactive Status} <> "")
This is what I have...not sure if I'm missing something.
-
Hello Laura!
So the COUNTIF formula only has 2 things to it, the criteria and the range. If you want 2 criteria, you will need the COUNTIFS function.
For the ISBLANK function, you just need to point it to a cell, so it would be something like =ISBLANK(@cell) or the not =NOT(ISBLANK(@cell))
Just to clarify, if Inactive Status is not blank, would you always count it? Or will you need something in the site number as well? Just to streamline the formula.
Try, =COUNTIF({Master Data | Inactive Status}, ISBLANK(@cell)) if you are only looking at the Inactive Status
Or, =COUNTIFS({Site Number}, NOT(ISBLANK(@cell)), {Master Data | Inactive Status}, ISBLANK(@cell)) if you need both Site Number not blank and Inactive Status blank.
Hope that helps
-
This is so helpful thank you!! I think the best fit will be the second one because I need both Site Number not blank and Inactive Status blank. Silly question...what is the @cell referring to exactly?
=COUNTIFS({Site Number}, NOT(ISBLANK(@cell)), {Master Data | Inactive Status}, ISBLANK(@cell))
-
@laura.sandoval @cell just means it's looking at each cell individually within the range you are specifying. You can use the ="" and <> "" if that makes more sense to you.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!