I'm stuck on a COUNTIFS formula
I'm stuck on a formula trying to get a total that only looks for specific criteria.
This is what I wrote: =COUNTIFS(Status53:Status114, NOT(HAS("Backlog", Priority53:Priority114, "High")))
It's not getting the the info I need. I'm trying to find out what tasks have a "High" Priority but aren't Status "Backlog".
I'm sure it's a simple steps that I'm missing. Thanks!
Help Article Resources
Check out the Formula Handbook template!