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