Hello! I am trying to create a formula which counts all items that are NOT assigned to a list of about 8 people. These will be totaled into an "Other" field.
Example: PMs include Bob, Sarah, Dee, David, and George. I have counts for how many projects are assigned to each of these people, no problem. Then I have a bunch of projects assigned to other people... instead of making individual counts for these, I'd like to group them into a total labeled "other." How can I count all fields which are NOT the PMs listed above?
I've done quite a bit of searching on this but for some reason am coming up dry, everything I have tried is not working.
Thanks!