Countifs project status is neither complete nor cancelled
I'm new to this, and I'm having issues with counting the number of projects where Project Type = X and Project Status does Not equal Complete or Cancelled. I'm fumbling my way through unsuccessfully. This will go on a dashboard where I have other working formulas, but this is out of my expertise.
Here's what I have so far. I'm sure there are obvious errors in it, but hopefully I can get not just the correct formula, but a little coaching/suggestions as well. I don't want to be the guy who constantly leans on others.
Any pointers would be much appreciated.
Help Article Resources
Check out the Formula Handbook template!