COUNTIFS and NOT Function

Silvia Frei

I'm looking to count the number of instances an epic is listed, but to exclude Closed and Done ones.

I am trying this formula which gives an error

=COUNTIFS(JIRA:JIRA, CONTAINS("TPM", @cell), [Issue Type]:[Issue Type], "Epic", NOT(Status:Status, "Closed", "Done"))

Any suggestions?

3.JPG

Stefan

Hi,

this works for me:

=COUNTIFS(JIRA:JIRA, CONTAINS("TPM", @cell), [Issue Type]:[Issue Type], ="Epic", Status:Status, <>"Closed", Status:Status, <>"Done")

For you too?

Greetings

Stefan

Silvia Frei

Perfect! Thanks :)