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
Check out the Formula Handbook template!