Countifs with Multiple Criteria in the Same Range
I am trying to create a formula to count the number of projects assigned to one person based on the phase of a project. My criteria is that is NOT one of the following phases: Construction, Completed, Punch, On Hold. I know I need to use <> to create the "not equal to" but for some reason, I am missing something to make it work for all of the phases I am trying to exclude.
Comments

I might need a bit more info, but if you are only looking for specific phase or phases, you can just ignore what you are not looking for. It might make your nested formula easier to work with.
Example:
=COUNTIFS([Status1]:[Status1], "On Schedule", [Assigned To]:[Assigned To], "Walt D")

I am not sure that works, but could be wrong. There are 5 statuses that I am trying to count all in the same formula. I thought I had been able to include multiple status in one formula, but I seem to have forgotten the correct way to do so...
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.8K Get Help
 410 Global Discussions
 219 Industry Talk
 457 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 297 Events
 37 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!