Countif a small or capital letter

[hodkd]

Is it possible to use the countif function to count a t seperate from a
T?

 

[RagDyer]

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!
==============================================

 

[Biff]

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

 

[Peo Sjoblom]

A bit less to type

=SUMPRODUCT(--(EXACT(A1:A100,"T")))

--
Regards,

Peo Sjoblom

(No private emails please)

 

[RagDyer]

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 !
---------------------------------------------------------------------------

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!
==============================================

 

[RagDyer]

Actually Peo, yours is more accurate as far as answering the OP, since the
Exact() *doesn't* count the "T's" contained in words.