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!

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!