count text

[Dr. Sachin Wagh]

How do I count the number of times "A" (text) apears in range A1:U5

Please help
--
Dr. Sachin Wagh
MBBS, DHA, DPH

[Biff]

Hi!

Try this:

=COUNTIF(A1:U5,"A")

Biff

>-----Original Message-----
>How do I count the number of times "A" (text) apears in
range A1:U5
>
>Please help
>--
>Dr. Sachin Wagh
>MBBS, DHA, DPH
>.
>

[Rowan]

=COUNTIF(A1:U5,"A")

Rowan

"Dr. Sachin Wagh" wrote:

> How do I count the number of times "A" (text) apears in range A1:U5
>
> Please help
> --
> Dr. Sachin Wagh
> MBBS, DHA, DPH

[Dr. Sachin Wagh]

Thanx Biff & Rowan

"Rowan" wrote:

> =COUNTIF(A1:U5,"A")
>
> Rowan
>
> "Dr. Sachin Wagh" wrote:
>
> > How do I count the number of times "A" (text) apears in range A1:U5
> >
> > Please help
> > --
> > Dr. Sachin Wagh
> > MBBS, DHA, DPH

[Bob Phillips]

If there could be more than one instance per cell, you can use

=SUMPRODUCT((LEN(A1:U5)-LEN(SUBSTITUTE(A1:U5,"A","")))/LEN("A"))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Biff" <[email protected]> wrote in message
news:[email protected]...
> Hi!
>
> Try this:
>
> =COUNTIF(A1:U5,"A")
>
> Biff
>
> >-----Original Message-----
> >How do I count the number of times "A" (text) apears in
> range A1:U5
> >
> >Please help
> >--
> >Dr. Sachin Wagh
> >MBBS, DHA, DPH
> >.
> >