| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Countif a small or capital letter
Is it possible to use the countif function to count a t seperate from a T? -- hodkd ------------------------------------------------------------------------ hodkd's Profile: http://www.excelforum.com/member.php...fo&userid=1002 View this thread: http://www.excelforum.com/showthread...hreadid=474941 |
|
#2
|
|||
|
|||
|
Try these:
=SUMPRODUCT(--ISNUMBER(FIND("T",A1:A100))) =SUMPRODUCT(--ISNUMBER(FIND("t",A1:A100))) -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "hodkd" wrote in message ... Is it possible to use the countif function to count a t seperate from a T? -- hodkd ------------------------------------------------------------------------ hodkd's Profile: http://www.excelforum.com/member.php...fo&userid=1002 View this thread: http://www.excelforum.com/showthread...hreadid=474941 |
|
#3
|
|||
|
|||
|
Hi!
Try this: =SUMPRODUCT(--(ISNUMBER(FIND("T",A1:A10)))) FIND is case sensitive, so this is not the same: =SUMPRODUCT(--(ISNUMBER(FIND("t",A1:A10)))) Biff "hodkd" wrote in message ... Is it possible to use the countif function to count a t seperate from a T? -- hodkd ------------------------------------------------------------------------ hodkd's Profile: http://www.excelforum.com/member.php...fo&userid=1002 View this thread: http://www.excelforum.com/showthread...hreadid=474941 |
|
#4
|
|||
|
|||
|
A bit less to type
=SUMPRODUCT(--(EXACT(A1:A100,"T"))) -- Regards, Peo Sjoblom (No private emails please) "RagDyer" wrote in message ... Try these: =SUMPRODUCT(--ISNUMBER(FIND("T",A1:A100))) =SUMPRODUCT(--ISNUMBER(FIND("t",A1:A100))) -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "hodkd" wrote in message ... Is it possible to use the countif function to count a t seperate from a T? -- hodkd ------------------------------------------------------------------------ hodkd's Profile: http://www.excelforum.com/member.php...fo&userid=1002 View this thread: http://www.excelforum.com/showthread...hreadid=474941 |
|
#5
|
|||
|
|||
|
Forgot to mention, this will count all *cells* that contain an upper or
lower case "T", anywhere within the cell.. "the fat cat" counts as *1* lower case "t". "The fat cat" counts as 1 lower *and* 1 upper case "T". -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "RagDyer" wrote in message ... Try these: =SUMPRODUCT(--ISNUMBER(FIND("T",A1:A100))) =SUMPRODUCT(--ISNUMBER(FIND("t",A1:A100))) -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "hodkd" wrote in message ... Is it possible to use the countif function to count a t seperate from a T? -- hodkd ------------------------------------------------------------------------ hodkd's Profile: http://www.excelforum.com/member.php...fo&userid=1002 View this thread: http://www.excelforum.com/showthread...hreadid=474941 |
|
#6
|
|||
|
|||
|
Actually Peo, yours is more accurate as far as answering the OP, since the
Exact() *doesn't* count the "T's" contained in words. -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Peo Sjoblom" wrote in message ... A bit less to type =SUMPRODUCT(--(EXACT(A1:A100,"T"))) -- Regards, Peo Sjoblom (No private emails please) "RagDyer" wrote in message ... Try these: =SUMPRODUCT(--ISNUMBER(FIND("T",A1:A100))) =SUMPRODUCT(--ISNUMBER(FIND("t",A1:A100))) -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "hodkd" wrote in message ... Is it possible to use the countif function to count a t seperate from a T? -- hodkd ------------------------------------------------------------------------ hodkd's Profile: http://www.excelforum.com/member.php...fo&userid=1002 View this thread: http://www.excelforum.com/showthread...hreadid=474941 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| COUNTIF or not to COUNTIF on a range in another sheet | Excel Worksheet Functions | |||
| Sentence with first letter in Capital, rest all in small. | Excel Discussion (Misc queries) | |||
| COUNTIF temporarily missed some cells | Excel Worksheet Functions | |||
| Have A Letter Reference A Name For An Intoduction | New Users to Excel | |||
| Countif - Countif | Excel Worksheet Functions | |||
Linear Mode
