ExcelBanter - count if cell if fill with text

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - count if cell if fill with text (https://www.excelbanter.com/excel-worksheet-functions/139195-count-if-cell-if-fill-text.html)

[email protected]

count if cell if fill with text

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

Trevor Shuttleworth

count if cell if fill with text

=COUNTA(A1:A25)

Regards

Trevor

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

T. Valko

count if cell if fill with text

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

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

All times are GMT +1. The time now is 03:54 PM.