Hassan Almaateeq
Reputation: 131
How to use OR in criteria with countif functions?
How to say find the word "Apple" or "Orange" by using or in the criteria instead of typing +countif as another criteria? I mean adding OR in the same criteria.
=countif(A1:A100,"apple|Orange")
Upvotes: 1
Views: 97
Answers (2)
Hassan Almaateeq
Reputation: 131
arrayformula(countifs(REGEXMATCH(A1:A100," (?i)apple|orange"), true, B1:B100, "banana"))
Upvotes: 0
player0
Reputation: 1
use:
=SUMPRODUCT(REGEXMATCH(A1:A100, "apple|Orange"))
to make it case insensitive use:
=SUMPRODUCT(REGEXMATCH(A1:A100, "(?i)apple|Orange"))
Upvotes: 1
Related Questions
- Countifs with OR criterias and ranges
- Count number of occurrences based on 2 conditions or Regexp
- How do I combine COUNTIF with OR
- How to check string text with OR logic using COUNTIF function in Google Sheets
- Google sheets COUNTIF function combined with OR function
- COUNTIF/COUNTIFS with text containing characters and OR logic doesn't work as expected
- How to use OR condition with COUNTIFS?
- COUNTIFS using REGEX as criteria
- How to use countif with or?
- Using OR with COUNTIFS