I need to count only the CELLS WITH TEXT in them and I do
not remember if "" refers to text or empty cells.

Thank you for any assistance you can offer in this matter.

Frank

Frank,

Count only counts numbers, CountA counts all, so the difference is (usually,
if you have no errors) text:

=COUNTA(A2:A7349)-COUNT(A2:A7349)

HTH,
Bernie
MS Excel MVP


"Frank" wrote in message
...
I need to count only the CELLS WITH TEXT in them and I do
not remember if "" refers to text or empty cells.

Thank you for any assistance you can offer in this matter.

Frank

=COUNTIF(A2:A7349,"<"&"")


--
Regards,
Ron

Ron,

That counts any non-blank cell.

HTH,
Bernie
MS Excel MVP


"Ron Coderre" wrote in message
...
=COUNTIF(A2:A7349,"<"&"")


--
Regards,
Ron

Yeah...I noticed that as soon as I clicked "Post". I was glad to see that
you had already sent an appropriate post so I didn't bother to send a
retraction/correction.

New rule: No posting before I've had my morning coffee :)
----
Regards,
Ron

Frank wrote:
I need to count only the CELLS WITH TEXT in them and I do
not remember if "" refers to text or empty cells.

Thank you for any assistance you can offer in this matter.

Frank

Also:

=COUNTIF(Range,"?*")

which skips numeric, empty, and cells with formula blanks (i.e., "").