Countifs with multiple criteria
Hi,
I'm trying to count rows from another cell that meet the following criteria:
- In Progress
- In a specific Department
- The Project Manager cell is not blank
I've figured out the formula for the first two, but I'm stuck trying to add the Not Blank part. Below, Range 3 is my Department, Range 2 is the status, and Range 1 is the Project Manager column.
=COUNTIFS({cPMO Dashboard Range 3}, "Corp Dev", {cPMO Dashboard Range 2}, ="In Progress", NOT(ISBLANK({cPMO Dashboard Range 1})))
I'd be grateful for any assistance.
Thank you!
Best Answer
-
Hey @Emily T.
Try this
=COUNTIFS({cPMO Dashboard Range 3}, "Corp Dev", {cPMO Dashboard Range 2}, ="In Progress", {cPMO Dashboard Range 1}, NOT(ISBLANK(@cell)))
or,
=COUNTIFS({cPMO Dashboard Range 3}, "Corp Dev", {cPMO Dashboard Range 2}, ="In Progress", {cPMO Dashboard Range 1}, <>"")
The last one is typically how I write it as it is less typing and less parentheses
Kelly
Answers
-
Hey @Emily T.
Try this
=COUNTIFS({cPMO Dashboard Range 3}, "Corp Dev", {cPMO Dashboard Range 2}, ="In Progress", {cPMO Dashboard Range 1}, NOT(ISBLANK(@cell)))
or,
=COUNTIFS({cPMO Dashboard Range 3}, "Corp Dev", {cPMO Dashboard Range 2}, ="In Progress", {cPMO Dashboard Range 1}, <>"")
The last one is typically how I write it as it is less typing and less parentheses
Kelly
-
Thank you! I used your second formula. I had tried a few variations of that but think I had left the second quote off at the end. Much appreciated!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!