COIUNTIFS as an OR

rwcanary99

Is their a way to use the COUNTIFS as an OR.

Currently, it will count all conditions of a cell that match the conditions given.

=COUNTIFS([Clothing Item]:[Clothing Item], "Jacket", [In Stock?]:[In Stock?], 1) will give me the count of all "Jackets" that are "In Stock"

However, I am looking to count if [Clothing Item]:[Clothing Item] is either a "Jacket" or a "Blouse".

jmyzk_cloudsmart_jp

Hi @rwcanary99

You can use OR(@cell="Jacket",@cell="Blouse"). Or you can just add with +.

In Stock and Jacket or Blouse

• =COUNTIFS([In Stock]:[In Stock], 1, [Clothing Item]:[Clothing Item], OR(@cell = "Blouse", @cell = "Jacket"))
• =COUNTIFS([In Stock]:[In Stock], 1, [Clothing Item]:[Clothing Item], "Jacket") + COUNTIFS([In Stock]:[In Stock], 1, [Clothing Item]:[Clothing Item], "Blouse")

Jacket or Blouse

• =COUNTIFS([Clothing Item]:[Clothing Item], OR(@cell = "Jacket", @cell = "Blouse"))
• =COUNTIFS([Clothing Item]:[Clothing Item], "Jacket") + COUNTIFS([Clothing Item]:[Clothing Item], "Blouse")

https://app.smartsheet.com/b/publish?EQBCT=e1d82ccbb5b54a9ba6763a034bcef847