Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Newbie, Countif Question
How do I Countif A1=B1 OR A1=C1 OR B1=C1, Trying to build something
and wondering, help if you can, thank you |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Newbie, Countif Question
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 " wrote: How do I Countif A1=B1 OR A1=C1 OR B1=C1, Trying to build something and wondering, help if you can, thank you |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Newbie, Countif Question
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 ! --------------------------------------------------------------------------- wrote in message oups.com... How do I Countif A1=B1 OR A1=C1 OR B1=C1, Trying to build something and wondering, help if you can, thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CountIf Function Question | Excel Discussion (Misc queries) | |||
total dumb newbie question | Excel Discussion (Misc queries) | |||
countif question | Excel Worksheet Functions | |||
Newbie Question: Data/Sort | New Users to Excel | |||
Newbie to charts question - projecting values between data points | Excel Discussion (Misc queries) |