Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif Help
Hi,
I have a list of 8 intitials in a row (C7 : J7), such as AR, IR, CS, RP etc. These are 4 golfing pairs. How do I count the number of times "AR" AND "IR" appear anywhere on row C7..J7? E.g. if both "AR and "IR" appear in range C7 : J7, the result of "1" would be returned in K7. if just "AR" appears, without "IR", the result of "0" would be returned in K7. I'm stumped - any assistance would be appreciated Tks - Rick |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif Help
Hi Richard
One way =MAX(0,SUMPRODUCT(--(C7:J7="AR")+(C7:J7="IR"))-1) Regards Roger Govier Richard wrote: Hi, I have a list of 8 intitials in a row (C7 : J7), such as AR, IR, CS, RP etc. These are 4 golfing pairs. How do I count the number of times "AR" AND "IR" appear anywhere on row C7..J7? E.g. if both "AR and "IR" appear in range C7 : J7, the result of "1" would be returned in K7. if just "AR" appears, without "IR", the result of "0" would be returned in K7. I'm stumped - any assistance would be appreciated Tks - Rick |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif Help
Hi May be this can help you.
just click another cell and copy this below format =COUNTIF(C:C,"AR") "Richard" wrote: Hi, I have a list of 8 intitials in a row (C7 : J7), such as AR, IR, CS, RP etc. These are 4 golfing pairs. How do I count the number of times "AR" AND "IR" appear anywhere on row C7..J7? E.g. if both "AR and "IR" appear in range C7 : J7, the result of "1" would be returned in K7. if just "AR" appears, without "IR", the result of "0" would be returned in K7. I'm stumped - any assistance would be appreciated Tks - Rick . |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif Help
Why would it be there more than once?
Although I don't feel that the spec is clear, here is a shot =INT(SUM(COUNTIF(C7:J7,{"AR","IR"}))/2) HTH Bob "Richard" wrote in message ... Hi, I have a list of 8 intitials in a row (C7 : J7), such as AR, IR, CS, RP etc. These are 4 golfing pairs. How do I count the number of times "AR" AND "IR" appear anywhere on row C7..J7? E.g. if both "AR and "IR" appear in range C7 : J7, the result of "1" would be returned in K7. if just "AR" appears, without "IR", the result of "0" would be returned in K7. I'm stumped - any assistance would be appreciated Tks - Rick |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
=countif ??? | Excel Discussion (Misc queries) | |||
How do I use a countif function according to two other countif fu. | Excel Worksheet Functions | |||
edit this =COUNTIF(A1:F16,"*1-2*")+COUNTIF(A1:F16,"*2-1*") | Excel Discussion (Misc queries) | |||
COUNTIF or not to COUNTIF on a range in another sheet | Excel Worksheet Functions | |||
COUNTIF in one colum then COUNTIF in another...??? | Excel Worksheet Functions |