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