# Summary Count by Assigned To and Status

Options
✭✭

Hello Smartsheet Community!

I hope everyone is doing well. I'm a bit of a newbie to what I consider more advanced formulas and need some help with a formula for the Summary section of a Smartsheet.

Essentially, what I need the formula to do is to count by Assigned To for any Task Names that are either Not Started OR In Progress.

I'm able to get the first part working where I get a count by Assigned To and one of the status indications. It's when I attempt to add BOTH status indications that things go #UNPARSEABLE on me.

Here's what I have so far:

=COUNTIFS([Assigned To]:[Assigned To], FIND("XYZ", @cell) > 0, Status:Status, <>"Not Started") which returns a count of tasks with a status of "Not Started" for the Assigned To of "XYZ" in this example.

How do I get it to OR the two statuses of "Not Started" OR "In Progress", so I just get a count of those two combined?

I hope this makes sense.

-Kurt

• ✭✭✭✭✭✭
Options

Try this:

=COUNTIFS([Assigned To]:[Assigned To], FIND("XYZ", @cell) > 0, Status:Status, OR(@cell = "Not Started", @cell = "In Progress"))

• ✭✭
Options

That works beautifully! Thank you so much! Simple enough but for some reason none of the "OR" statements I was trying worked.

I appreciate the help!

• ✭✭✭✭✭✭
Options

Happy to help. 👍️

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!