Countifs with an OR

[Upex]

Hi all, hope you're well.

Trying to count rows that meet numerous conditions but I cannot figure out how to embed an 'OR' or such like. I want to count if range 1-4 all match and then if range5 is a match OR if range6 is a match, but to only count once if both 5 and 6 match and not count at all if neither 5 nor 6 is a match.

1,2,3,4,5,6 = true = count 1
1,2,3,4,5 = true = count 1
1,2,3,4,6 = true = count 1
1,2,3,4 = true = no count

Tried various things but can't get anything to work - any ideas?

countifs(range1,criteria1,range2,criteria2..... OR(AK:AK,BD:BD),{"*term1*","*term2*","*term3*"})

countifs((range1,criteria1,range2,criteria2.....OR(AK:AK={"*term1*","*term2*","*term3*"},BD:BD={"*term1*","*term2*","*term3*"})

type thing - but that works - TIA

 

[RoryA]

I'd probably use FILTER for this as you have 365, but you should be able to use something like:

=SUM(countifs((range1,criteria1,range2,criteria2,AK:AK,{"*term1*","*term2*","*term3*"},BD:BD,{"*term1*";"*term2*";"*term3*"}))

Note the semicolons, not commas, in the second array.