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???