| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 . |
|
#3
|
|||
|
|||
|
=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 |
|
#4
|
|||
|
|||
|
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 |
|
#5
|
|||
|
|||
|
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 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to count occcurence of specific text block in a column | Excel Discussion (Misc queries) | |||
| Count the text in a column - Part II | Excel Discussion (Misc queries) | |||
| Count Occourences of formatted text | Excel Discussion (Misc queries) | |||
| want if cell containts text, then increase count by one | Excel Worksheet Functions | |||
| how do I 'count' the number of cells with a text in red or black? | Excel Worksheet Functions | |||
Linear Mode
