|
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 |
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 |
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 |
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 |
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 |
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 |
| All times are GMT +1. The time now is 06:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com