count text
 

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

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

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
.

=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

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

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" wrote in message
...
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
.