Home |
Search |
Today's Posts |
#1
|
|||
|
|||
count cells that contain text entries
In Excell how would I count cells that contain both text and numbers that are
formated as text? Example in A1 through A210 there are entries such as ME90.05, M80304, BE80.04 |
#2
|
|||
|
|||
One way:
If you want to count actual numbers, too, use COUNTA(): =COUNTA(A1:A210) If you want to exclude actual numbers (but not text numbers): =COUNTA(A1:A210)-COUNT(A1:A210) In article , "Debi" wrote: In Excell how would I count cells that contain both text and numbers that are formated as text? Example in A1 through A210 there are entries such as ME90.05, M80304, BE80.04 |
#3
|
|||
|
|||
JE McGimpsey wrote...
One way: If you want to count actual numbers, too, use COUNTA(): =COUNTA(A1:A210) This also includes any error or boolean values in the count. If you want to exclude actual numbers (but not text numbers): =COUNTA(A1:A210)-COUNT(A1:A210) This would also include any error or boolean values in the count. FWIW, counting just text is fairly simple if obscure. =COUNTIF(range,"*") Counting text that could be converted into numbers is a bit trickier, requiring an array formula. =COUNT(-range)-COUNT(range) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to strip figures from cells text strings | Excel Discussion (Misc queries) | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
Cells formated as text do not always display properly | Excel Discussion (Misc queries) | |||
text wrap in merged cells | Excel Discussion (Misc queries) | |||
Combining & formatting cells with text - Excel 2002 | Excel Discussion (Misc queries) |