software

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

Assuming your datais arranged in range A1:C4 like thisgt;

546
561
442
121

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

quot; wrote:

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

Does this work for you:

=SUMPRODUCT(($A$1:$A$4=$B$1:$B$4) (B1:B4=C1:C4))
?
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
gt; wrote in message oups.com...
gt; How do I Countif A1=B1 OR A1=C1 OR B1=C1, Trying to build something
gt; and wondering, help if you can, thank you
gt;