countif, multiple value range PLEASE HELP

[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

 

[Pete_UK]

This is slightly shorter:

=SUMPRODUCT((A22=A1)+(A22=B1)+(A22=C1)+(A22=D1))

Hope this helps.

Pete

 

[Herbert Seidenberg]

=SUMPRODUCT(COUNTIF(RangeB,RangeA))