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!


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!