Here is my situation:
I have a PMO tracking sheet that is tracking many projects through various statuses. I am putting together a metrics sheet so I can create charts to put on a dashboard.
In the metric sheet I am trying to count the number of projects by department where the status is not Complete or Cancelled.
I can't get the formula right...
Here is what I am trying to at least exclude Complete projects, but banging my head against the wall. Why can't there be a formula wizard/builder??
=IF(({StatusRange}<>"Complete")),(COUNTIFS({DepartmentRange}, Counts@row),)