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,"*")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookup the last alpha numeric value in a column 4
Extract alpha from a cell 1
Excel Find and Replace 1
Separating Numerical and Alpha Data in cells 6
Alpha sorting (with a twist...?) 3
Adding alpha-numeric value in from all alphabetic content in a col 3
How do I count alpha codes in a range of cells in a row? 1
Using text values in Pivot Tables 5

Top