Alpha & Numeric Counts in Excel

  • Thread starter Programmer wanna be
  • Start date
P

Programmer wanna be

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
 
C

CLR

=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
 
H

Harlan Grove

CLR said:
=COUNTA(A1:A6) results as 6
=COUNT(A1:A6) results as 4
=COUNTA(A1:A6)-COUNT(A1:A6) results as 2
Click to expand...
....

FWIW, the last formula could be replaced by

=COUNTIF(A1:A6,"*")
 
Top