Newbie, Countif Question

[Mitymack]

How do I Countif A1=B1 OR A1=C1 OR B1=C1, Trying to build something
and wondering, help if you can, thank you

 

[Guest]

Hi,

Assuming your datais arranged in range A1:C4 like this>

5 4 6
5 6 1
4 4 2
1 2 1

Use the following array formula (Ctrl+Shift+Enter) in cell C7

=COUNT(IF(($A$1:$A$4=$B$1:$B$4)+($A$1:$A$4=$C$1:$C$4)+($B$1:$B$4=$C$1:$C$4),$C$1:$C$4))

Regards,

Ashish Mathur

 

[Ragdyer]

Does this work for you:

=SUMPRODUCT(($A$1:$A$4=$B$1:$B$4)+(B1:B4=C1:C4))
?