OR Syntax
Hello Community,
What's wrong with my syntax below:
=COUNTIF(OR([Column 1]:[Column 1], CONTAINS("A", @cell)), [Column 1]:[Column 1], CONTAINS("B", @cell))
If it's not obvious, want a count from Column 1 when "A", or "B" are present.
Error is "#INCORRECT ARGUMENT SET" if it helps.
Jason
Best Answer
-
@Jason Wirl I think what you're looking for is this:
=COUNTIFS([Column 1]:[Column 1], (OR((CONTAINS("A", @cell)), (CONTAINS("B", @cell)))))
Haven't tested; let me know how you fare!
Answers
-
@Jason Wirl I think what you're looking for is this:
=COUNTIFS([Column 1]:[Column 1], (OR((CONTAINS("A", @cell)), (CONTAINS("B", @cell)))))
Haven't tested; let me know how you fare!
-
Got it! Thank you! I thought it might have been "COUNTIFS" but when looking at the Formula Example sheet, I read the example as the functionality, which made me think the evaluation range had to be in a row. That took me off of COUNTIFS. Also, wasn't sure if the OR was applied to the whole formula (i.e. after the "IF"), or to just the "A" and "B" arguments.
Regardless, works perfectly. And without testing!
Jason
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!