# I'm having issues with COUNTIFS - can someone help?

Options
1. This works =COUNTIF(Priority:Priority, "P1")
2. This works =COUNTIFS(Priority:Priority, "P1") + COUNTIF(Priority:Priority, "P2")
3. This works =COUNTIFS(Priority:Priority, "P1") + COUNTIF(Status:Status, "Done") but it adds them up

I can't get the countifs to only show records that are P1 AND (Done OR Declined). I've looked through the community and tried these and none of them work:

1. =COUNTIFS(Priority:Priority,”P1”, Status:Status, “Done”) -leaving out Declined just to see
2. =COUNTIFS(Priority:Priority, “P1", Status:Status, OR(@cell =
Done”)) Tried using the @cell variable

What I really want is for something like this to work; any ideas?

1. =COUNTIFS(Priority:Priority, “P1”, Status:Status, OR(@cell =
Done”, @cell = “Declined”))
2. =COUNTIFS([Priority:Priority], “P1”, [Status]:[Status], OR(@cell="Done", @cell=“Declined")

Tags:

• Options

Closing parens didn't copy in that last example, but I have tried

=COUNTIFS(Priority:Priority, “P1”, [Status]:[Status], OR(@cell="Done", @cell=“Declined"))

• ✭✭✭✭
Options

Try,

=COUNTIFS(Priority:Priority, @cell = "P1", Status:Status, OR(@cell = "Done", @cell = "Declined"))

~MR

• Options

Thank you!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!