Formula help

JessMc3

How do i show an accurate count of where one individual - say myself is the primary owner and a count of how many tasks are open excluding the "completed" tasks

I tried this and it counts everything I own as well as everything that is not completed for the entire team

=COUNTIF({Primary Owner}, "Jessica McNamara") + COUNTIF({Status}, <>"Completed")

I only have 13 outstanding tasks and this formula above returns 118

I need to count how many tasks each user owns in primary owner and exclude "completed" in status column

Thomas Bostwick

I think you need to use the following formula:

=COUNTIFS([Primary Owner]:[Primary Owner], @cell = "Jessica McNamara", Status:Status, NOT(CONTAINS("Complete", @cell)))