ExcelBanter - Alpha & Numeric Counts in Excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Alpha & Numeric Counts in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/20544-alpha-numeric-counts-excel.html)

Programmer wanna be

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

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

"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

Harlan Grove

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

CLR

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

All times are GMT +1. The time now is 01:41 AM.