Countif formula; exclude completed status

ashley.elma

Hello,

I currently have the formula to count how many priority levels each team has but would like to exclude the completed items from the count. Is there an additional piece of the formula that I need to include?

Jason Duryea

Try this formula

=COUNTIFS([Priority Level]:[Priority Level], "Medium", [Team Owner]:[Team Owner], "CLSRG", [Status]:[Status], <>”Completed”)

Jason Duryea

Add another condition to your COUNTIFS for [Status]2:[Status]62, <>”Completed”

ashley.elma

How would I add the condition to this formula since the different variations that I have tried haven't been working?

=COUNTIFS([Priority Level]:[Priority Level], "Medium", [Team Owner]:[Team Owner], "CLSRG")

Jason Duryea

Try this formula

=COUNTIFS([Priority Level]:[Priority Level], "Medium", [Team Owner]:[Team Owner], "CLSRG", [Status]:[Status], <>”Completed”)

ashley.elma

Thanks that worked!