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