Perhaps try:
=SUMPRODUCT((ISTEXT(Range))*(TRIM(Range)<""))
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"sbrimley" wrote in message
...
Thank you, it worked but with one small problem, I have more rows than the
number that is being returned from the formula you gave me. I am off by
10.
I even took into consideration my header rows
I used the second formula, just counting text. If there is a space after
the entry would that cause a problem?