If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Conditional COUNTIF
What is wrong with this formula
IF(COUNTIF($AQ2:$BB2,OR("ABC","DEF")),"T","F") |
#2
|
|||
|
|||
Conditional COUNTIF
Sara;344766 Wrote: What is wrong with this formula IF(COUNTIF($AQ2:$BB2,OR("ABC","DEF")),"T","F")You can't use the OR operator like that you need to use an array like this: =IF(COUNTIF($AQ2:$BB2,{"ABC","DEF"}),"T","F") -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=96462 |
#3
|
|||
|
|||
Conditional COUNTIF
Simon Lloyd;344786 Wrote: You can't use the OR operator like that you need to use an array like this: =IF(COUNTIF($AQ2:$BB2,{"ABC","DEF"}),"T","F")Ignor e that rubbish i just sent you - don't know why i did that, its early hours of the morning here, use this: =IF(OR(COUNTIF($AQ2:$BB2,"ABC"),COUNTIF($AQ2:$BB2, "DEF")),"T","F") -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=96462 |
#4
|
|||
|
|||
Conditional COUNTIF
Try it like this:
=IF(SUM(COUNTIF($AQ2:$BB2,{"ABC","DEF"})),"T","F") -- Biff Microsoft Excel MVP "Sara" wrote in message ... What is wrong with this formula IF(COUNTIF($AQ2:$BB2,OR("ABC","DEF")),"T","F") |
#5
|
|||
|
|||
Conditional COUNTIF
Here's one alternative which serves your underlying intents:
=IF(SUMPRODUCT(--ISNUMBER(MATCH($AQ2:$BB2,{"ABC","DEF"},0))),"T","F ") Success? Pl click the YES button below -- Max Singapore http://savefile.com/projects/236895 Downloads:25,000 Files:370 Subscribers:68 xdemechanik --- "Sara" wrote: What is wrong with this formula IF(COUNTIF($AQ2:$BB2,OR("ABC","DEF")),"T","F") |
Thread Tools | |
Display Modes | |
|
|