count if cell if fill with text

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

chiuinggum@hotmail.com - 17 Apr 2007 05:54 GMT

if a cell is fill up with text it is consider one count. what is the formula
to use?

Reply to this Message

Trevor Shuttleworth - 17 Apr 2007 06:36 GMT

=COUNTA(A1:A25)

Regards

Trevor

> if a cell is fill up with text it is consider one count. what is the
> formula
> to use?

Reply to this Message

T. Valko - 17 Apr 2007 07:43 GMT

COUNTA will count *all* non-empty cells. Both TEXT and NUMBERS.

To count *only* cells that contain TEXT (this includes formula blanks):

=COUNTIF(A1:A10,"*")

Biff

> if a cell is fill up with text it is consider one count. what is the
> formula
> to use?

Reply to this Message