COUNT Cat in A if B is a - =COUNTIFS(A2:A11,"Cat", B2:B11, "a")
COUNT Cat in A if B is a BUT Exclude if Column C is an x, y or z =COUNTIFS(A2:A11,"Cat", B2:B11, "a", C2:C11, "<>x", C2:C11, "<>y", C2:C11, "<>z")
Was wondering if my range was very long is there a way to add the range in formula, something like
=COUNTIFS(A2:A11,"Cat", B2:B11, "a", C2:C11 Doesn't CONTAIN anyting in Range E2:E4
Range is A2:E11
COUNT Cat in A if B is a BUT Exclude if Column C is an x, y or z =COUNTIFS(A2:A11,"Cat", B2:B11, "a", C2:C11, "<>x", C2:C11, "<>y", C2:C11, "<>z")
Was wondering if my range was very long is there a way to add the range in formula, something like
=COUNTIFS(A2:A11,"Cat", B2:B11, "a", C2:C11 Doesn't CONTAIN anyting in Range E2:E4
Range is A2:E11
cat | a | x | x | |
dog | b | v | y | |
cat | a | y | z | |
cat | b | z | ||
apple | a | x | ||
banana | d | y | ||
cherry | c | z | ||
cat | b | z | ||
cat | a | p | ||
cat | a | t |