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
Need Help with Alpha into Numeric expressions (not ASCII/ANSI/Etc. 9
Alpha sorting (with a twist...?) 3
Maintaining text data format in a pivot table 0
Using text values in Pivot Tables 5
Adding alpha-numeric value in from all alphabetic content in a col 3
formula with alpha char in cell 7

Top