D
Dr. Sachin Wagh
How do I count the number of times "A" (text) apears in range A1:U5
Please help
Please help
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Biff
Hi!
Try this:
=COUNTIF(A1:U5,"A")
Biff
Try this:
=COUNTIF(A1:U5,"A")
Biff
R
Rowan
=COUNTIF(A1:U5,"A")
Rowan
Rowan
D
Dr. Sachin Wagh
B
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)
=SUMPRODUCT((LEN(A1:U5)-LEN(SUBSTITUTE(A1:U5,"A","")))/LEN("A"))
--
HTH
RP
(remove nothere from the email address if mailing direct)