Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 5th 05, 02:10 AM
Programmer wanna be
 
Posts: n/a
Default 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

  #2   Report Post  
Old April 5th 05, 02:36 AM
CLR
 
Posts: n/a
Default

=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



  #3   Report Post  
Old April 5th 05, 05:21 AM
Harlan Grove
 
Posts: n/a
Default

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

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






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Counts Cells WZabrouski Excel Discussion (Misc queries) 3 March 17th 05 04:23 AM
how to convert GETPIVOTDATA from excel 2000 to excel 2002... Need_help_on_excel Excel Worksheet Functions 1 March 15th 05 02:08 AM
I get a program error when I download an excel template Ladybug Excel Discussion (Misc queries) 3 March 4th 05 01:02 AM
convert a number in Excel from numeric to text, i.e. "1" to "one" buenavisionpaul Excel Worksheet Functions 1 January 27th 05 07:30 PM
Difference in number of Excel NewsGroups 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.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017