L
laandmc
I have a set of data where I want to count some values with a range of
different outcomes:
a b c d
a a c e
0 = COUNTIF(A22,OR(A1,B1,C1,D1))
3 <-- Answer I want to get
The Bottom answer is what I want to get
The Top answe is what I am getting
Is there a way of doing this without doing a long formula such as:
= COUNTIF(A22,A1)+COUNTIF(A22,B1)+COUNTIF(A22,C1)+COUNTIF(A22,D1)
My formula is already very complicated so I want to avoid doing this if
possible
different outcomes:
a b c d
a a c e
0 = COUNTIF(A22,OR(A1,B1,C1,D1))
3 <-- Answer I want to get
The Bottom answer is what I want to get
The Top answe is what I am getting
Is there a way of doing this without doing a long formula such as:
= COUNTIF(A22,A1)+COUNTIF(A22,B1)+COUNTIF(A22,C1)+COUNTIF(A22,D1)
My formula is already very complicated so I want to avoid doing this if
possible