Formula for specific status options not working

SherryBain

The current formula below is just returning a "0" when it should show a count of "3" according to the data

Purpose: Trying to show total number of "In Progress FPI" Status that filters only on "Critical" AND "High" Priority

Formula:

=COUNTIFS(Status:Status, "In Progress FPI", Priority:Priority, "Critical", Priority:Priority, "High")

Data snapshot:

Thanks for any guidance you can provide!

brianw

I think you forgot to bracket your columns your referencing. Does this work?

=COUNTIFS([Status:Status], "In Progress FPI", [Priority:Priority], "Critical", [Priority:Priority[, "High")

Paul H

=COUNTIFS(Status:Status, "In Process FPI", Priority:Priority, OR(@cell = "High", @cell = "Critical"))

brianw

I was able to get this to work using this formula

=COUNTIF(Status:Status, "In Progress FPI") + COUNTIFS(Priority:Priority, "High", Status:Status, "Critical")