CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formulacountif
mschli
mschli

Reputation: 1

Google sheets COUNTIF function combined with OR function

I've attached a photo of what I am trying to do below. I need to look at multiple columns and if any of them contain "apple" I need to count that row once. I am having a lot of trouble finding the solution.
Here's a photo of what I am trying to do

Here's a photo of what I am trying to do.

Upvotes: 0

Views: 903

Answers (1)

player0
player0

Reputation: 1

try:

=INDEX(SUM(N(MMULT(REGEXMATCH(B2:E, "(?i)apple")*1, FLATTEN(COLUMN(B2:E)^0))<>0)))

enter image description here

Upvotes: 2

Related Questions