Count if exclude a column with blanks

Ashley Johnson

I would like to summarize information on how many green "progress" icons we have but exclude those with also a green "state" icon. I tried this but it didn't work:

=COUNTIFS(CAPABILITY:CAPABILITY, CONTAINS("Development", @cell), [Progress Alert]:[Progress Alert], "Green", State:State, NOT(@cell = "Gray"), State:State, NOT(@cell), [Cross Functional Team or Activity]:[Cross Functional Team or Activity], "INTEROPERABILITY")

Any ideas?

Paul Newcome

Here you go...

COUNTIFS(CAPABILITY:CAPABILITY, CONTAINS("Development", @cell), [Progress Alert]:[Progress Alert], "Green", State:State, AND(@cell <> "Gray", @cell <> ""), [Cross Functional Team or Activity]:[Cross Functional Team or Activity], "INTEROPERABILITY")

Paul Newcome

Try this:

COUNTIFS(CAPABILITY:CAPABILITY, CONTAINS("Development", @cell), [Progress Alert]:[Progress Alert], "Green", State:State, @cell <> "Gray", [Cross Functional Team or Activity]:[Cross Functional Team or Activity], "INTEROPERABILITY")

Ashley Johnson

Hi Paul,

Thank you for your response.

I want to exclude rows with state gray or state blank. Does this formula give me that?

Paul Newcome

Here you go...

COUNTIFS(CAPABILITY:CAPABILITY, CONTAINS("Development", @cell), [Progress Alert]:[Progress Alert], "Green", State:State, AND(@cell <> "Gray", @cell <> ""), [Cross Functional Team or Activity]:[Cross Functional Team or Activity], "INTEROPERABILITY")