I am having trouble using "And", "OR" & "Countif(s)" to build a formula.

SmarsheetNewb

Hello,

I am attempting to come up with a sheet summary formula that counts cells if they meet at least one of 3 different statuses in the same column, AND also meet one of 5 different statuses in a separate column.

So using the screenshot I've provided as an example (although it doesn't have 5 different statuses in the same column) I would like a sheet summary formula that says =COUNTIF([Item Number]:[Item Number], "C001" OR "COO2" OR "COO3" OR "COO4" AND Status:Status, "Green" OR "Yellow" OR "Red"

My apologies in advance if I worded this question in a less than optimal manner.

Screenshot 2023-08-25 154417.png

.

Carson Penticuff

Try this:

=COUNTIFS([Item Number]:[Item Number], OR(@cell = "C001", @cell = "COO2", @cell = "COO3", @cell = "COO4"), [Status]:[Status], OR(@cell = "Green", @cell = "Yellow", @cell = "Red"))

Carson Penticuff

Try this:

=COUNTIFS([Item Number]:[Item Number], OR(@cell = "C001", @cell = "COO2", @cell = "COO3", @cell = "COO4"), [Status]:[Status], OR(@cell = "Green", @cell = "Yellow", @cell = "Red"))

SmarsheetNewb

Thank you so much! I was able to use your response to figure out exactly what I needed to do!

Carson Penticuff

👍