I'm stuck on a COUNTIFS formula

Josh L.

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!

ChloeSmith

Hello,

Does this work? =COUNTIFS(Status53:Status114, NOT(@cell = "Backlog"), Priority53:Priority114, "High")

ChloeSmith

Hello,

Does this work? =COUNTIFS(Status53:Status114, NOT(@cell = "Backlog"), Priority53:Priority114, "High")

Josh L.

@ChloeSmith Hallelujah! Yes, it worked! I've been trying different options for over an hour. Thank you!

ChloeSmith

@Josh L. Woot!! Glad it worked!