Countifs using a Or Function
Answers
-
@Michael Foster Happy to help. 👍️
The reason the OR function doesn't work is because the OR needs to have a logical statement which includes some kind of criteria whereas the placement of the OR that you would have needed within this particular COUNTIFS would have been in the range section (no criteria).
Now if you had wanted to specify two different criteria for the same range, then you could have used the OR in the criteria section.
=COUNTIFS({Range}, OR(@cell = "Paul", @cell = "Mike", @cell = "Michael"))
-
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.3K Get Help
- 386 Global Discussions
- 212 Industry Talk
- 446 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 292 Events
- 35 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!