Countif with OR?
We have a department where the Project Managers can be assigned as the design PM and/or the construction PM. Please see the example below:
In this snapshot, I filtered the view to where D-PM is one of M. Johnson or C-PM is one of M. Johnson. In the D-PM column he is listed 3 times and the C-PM column he is listed 5 times.
I would like a formula where it returns the total number of projects he has worked on (6). I've tried COUNTIFS, OR statements, nested statements, etc... but I cannot seem to get it to return the correct number. There is another column (not shown here) for status that I would also like to use as a filter in the counting formula.
Any help would be much appreciated!
Help Article Resources
Check out the Formula Handbook template!