COIUNTIFS as an OR

Options

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".

Tags:

Answers

  • jmyzk_cloudsmart_jp
    jmyzk_cloudsmart_jp ✭✭✭✭✭✭
    Options

    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")


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!