COIUNTIFS as an OR
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
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 210 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 300 Events
- 33 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!