| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Alpha & Numeric Counts in Excel
I am trying to add alpha and numerical together. Basically if there
are any alpha characters in a column then deduct them from the total number of all the numerical added together. Make sense, please help. Number of numeric characters (should be treated as one value each) minus Number of Alpha characters (will only be one character) in a column. A 10 F 16 22 24 6(total)-2(alpha) = 4 Thank you |
|
#2
|
|||
|
|||
|
=COUNTA(A1:A6) results as 6
=COUNT(A1:A6) results as 4 =COUNTA(A1:A6)-COUNT(A1:A6) results as 2 Vaya con Dios, Chuck, CABGx3 "Programmer wanna be" wrote in message om... I am trying to add alpha and numerical together. Basically if there are any alpha characters in a column then deduct them from the total number of all the numerical added together. Make sense, please help. Number of numeric characters (should be treated as one value each) minus Number of Alpha characters (will only be one character) in a column. A 10 F 16 22 24 6(total)-2(alpha) = 4 Thank you |
|
#3
|
|||
|
|||
|
"CLR" wrote...
=COUNTA(A1:A6) results as 6 =COUNT(A1:A6) results as 4 =COUNTA(A1:A6)-COUNT(A1:A6) results as 2 .... FWIW, the last formula could be replaced by =COUNTIF(A1:A6,"*") |
|
#4
|
|||
|
|||
|
Cool..........thanks Harlan...
Vaya con Dios, Chuck, CABGx3 "Harlan Grove" wrote in message ... "CLR" wrote... =COUNTA(A1:A6) results as 6 =COUNT(A1:A6) results as 4 =COUNTA(A1:A6)-COUNT(A1:A6) results as 2 ... FWIW, the last formula could be replaced by =COUNTIF(A1:A6,"*") |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Counts Cells | Excel Discussion (Misc queries) | |||
| how to convert GETPIVOTDATA from excel 2000 to excel 2002... | Excel Worksheet Functions | |||
| I get a program error when I download an excel template | Excel Discussion (Misc queries) | |||
| convert a number in Excel from numeric to text, i.e. "1" to "one" | Excel Worksheet Functions | |||
| Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
Linear Mode
