Countifs and NOT(ISBLANK)
Hi, I'm hoping someone can point me in the correct direction.
I'm trying to get a Count of the amount of unit of a specified category if they are not yet assigned.
Basically, I have Column "STOCK" that I want to count what is assigned in box SEARCH201 if "ASSIGNED" is empty. This is what I have so far:
=COUNTIFS(STOCK1:STOCK200, SEARCH201, NOT(ISBLANK(ASSIGNED1:ASSIGNED200)))
But I get: incorrect argument
Thanks for any help you can provide!
Answers
-
we need to use @cell to check what's blank, something like this
=COUNTIFS(STOCK1:STOCK200, SEARCH201,ASSIGNED1:ASSIGNED200, NOT(ISBLANK(@cell)))
This could give you more help https://help.smartsheet.com/articles/2476491-create-efficient-formulas-with-at-cell
Parul Mishra
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!