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


"hodkd" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[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

"hodkd" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Peo Sjoblom]

A bit less to type

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

--
Regards,

Peo Sjoblom

(No private emails please)


"RagDyer" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in
> message news:[email protected]...
>>
>> 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
>>
>

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

"RagDyer" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in
> message news:[email protected]...
> >
> > 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
> >
>

[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.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Peo Sjoblom" <[email protected]> wrote in message
news:[email protected]...
> A bit less to type
>
> =SUMPRODUCT(--(EXACT(A1:A100,"T")))
>
> --
> Regards,
>
> Peo Sjoblom
>
> (No private emails please)
>
>
> "RagDyer" <[email protected]> wrote in message
> news:[email protected]...
> > 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" <[email protected]> wrote in
> > message news:[email protected]...
> >>
> >> 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
> >>
> >
>