Count IFS and NOT(IsBlank

Good morning!
I am attempting to use a sheet to count instances on another sheet and keep getting an Incorrect Argument error on the rows that should be counted.
I am counting the number of jobs with a particular type where one column is blank and another is not blank.
So count by Job Type, if Engineering Completion Date is blank, and Division Name is not blank (this is to weed out the additional rows on the sheet with no data in them). I have attached a screenshot below. For other branches I can simply put Division is equal to "X" but this branch has two locations so I thought it may be easier to just use "Not Blank".
Thanks for your help!
Best Answer
-
It looks like you misplaced a parenthesis. Take one from the end and move it to after the NOT(ISBLANK(@cell).
Right now you are closing out the ISBLANK function, but then everything after that is part of the NOT function because it isn't closed out.
Answers
-
It looks like you misplaced a parenthesis. Take one from the end and move it to after the NOT(ISBLANK(@cell).
Right now you are closing out the ISBLANK function, but then everything after that is part of the NOT function because it isn't closed out.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 152 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!