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![Smile :) :)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
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