Remember Me?

#1
April 5th 05, 02:10 AM
 Programmer wanna be Posts: n/a
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 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
April 5th 05, 02:36 AM
 CLR Posts: n/a

=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 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
April 5th 05, 05:21 AM
 Harlan Grove Posts: n/a

"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
April 5th 05, 11:12 AM
 CLR Posts: n/a

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

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post WZabrouski Excel Discussion (Misc queries) 3 March 17th 05 04:23 AM Need_help_on_excel Excel Worksheet Functions 1 March 15th 05 02:08 AM Ladybug Excel Discussion (Misc queries) 3 March 4th 05 01:02 AM buenavisionpaul Excel Worksheet Functions 1 January 27th 05 07:30 PM Hari Prasadh Excel Discussion (Misc queries) 1 January 25th 05 12:32 PM

All times are GMT +1. The time now is 08:40 PM.