formula query for count if all x1,x2,x3 columns contain a1 or b1 inputs.

usha

Hi , I need to write formula for below mentioned requirement.

x1 column has any of a1 or b1

& x2 column has any of a1 or b1

& X3 column has any of a1 or b1

Count the total rows returned with above condition

Thanks

Ibrahim Khaleel

Please try below formula, Replace your column name with X1, X2 and X3

==countifs(X1:X1,="a1", X1:X1,="b1") + countifs(X2:X2,="a1", X2:X2,="b1") + countifs(X3:X3,="a1", X3:X3,="b1")

usha

Thank you