Count if exclude a column with blanks
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")
Help Article Resources
Check out the Formula Handbook template!