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