How To find identical values

[marcgijsman@hotmail.com]

Hi
I have a sheet with in which i like to find identical values and report
in how many times does this value appear.
A B C D
x y z x =3
r x r y =1
f f z z =2
r =1
f =2
I have tried several functions but no luck, can anyone tell me how to
do this?

Thanks in advance

[Bondi]

marcgijs...@hotmail.com wrote:
> Hi
> I have a sheet with in which i like to find identical values and report
> in how many times does this value appear.
> A B C D
> x y z x =3
> r x r y =1
> f f z z =2
> r =1
> f =2
> I have tried several functions but no luck, can anyone tell me how to
> do this?
>
> Thanks in advance

Hi,
Maybe you can use something like:

=COUNTIF(A1:C3,"f")

Regards,
Bondi