Thread: count text
View Single Post
  #5   Report Post  
Bob Phillips
 
Posts: n/a
Default

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
.