I need to count a row with something in it
Thank you IT WORKS!! ; 0)
You’re awesome!!
"RagDyer" wrote:
As long as your data has a *single* alpha character, and no spaces,
you could create a "helper" column to extract the numeric data,
and then just total that helper column.
With original data starting in A1,
try this in B1:
=IF(A10,--REPLACE(A1,MIN(SEARCH(
{"a","b","c","d","e","f","g","h","i","j","k","l"," m","n","o","p","q","r","s","t","u","v","w","x","y" ,"z"},
A1&"abcdefghijklmnopqrstuvwxyz")),1,""),"")
And copy down as needed.
Then Sum Column B.
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Elvira" wrote in message
...
A100
1B00
10C0
D100
=
400
I need to add the rows the problem that I am running into is that it does
not recognize the number because of the alpha included in the number
I hope this explains it a little better
"T. Valko" wrote:
It's not clear what you want. Can you provide a more detailed
explanation?
--
Biff
Microsoft Excel MVP
"Elvira" wrote in message
...
I have a simmilar problem. I need to count rows with combinations of
letters
and alpha i.e. 45A111 + 45A222 should equal 90333. I need the formula
to
exclude the numeric factor.
Please advice
"T. Valko" wrote:
You're welcome. Thanks for the feedback!
--
Biff
Microsoft Excel MVP
"Rick" wrote in message
...
T. Valko..... You are the best..... this stuff is sooooo simple if
you
know
the basic rules ..... oh yea just like life
Thanks again!!!
"T. Valko" wrote:
Maybe this:
=COUNTA(D61:J61)
That will return the count of cells in the range that are not
empty.
--
Biff
Microsoft Excel MVP
"Rick" wrote in message
...
I have been following this strem but have not seen something that
I
need
....
I need to count a row (e.g., d61:j61) with anything in it -
either a
number
or word .... can one of you please help me???
|