Count if?

[susanquinn]

Does anyone know how to write a function that will count how many cells
in a certain range have text in them? Not a CERTAIN text, but ANY text.

 

[duane]

how about counta(range) - countif(range,">0") to count # of cells with
nonnumeric entries?

 

[Biff]

When you say "text", do you mean TEXT and not numeric
values? Or, does "text" mean "anything"?

For TEXT only:

=SUMPRODUCT(--(ISTEXT(A1:A7)),--(A1:A7<>""))

Biff

 

[Tom Ogilvy]

Assuming they will only contain text or numbers or be blank:
=CountA(A1:A10)-Count(A1:A10)

if they could have errors then it would be more complex.

 

[Frank Kabel]

Hi
try
=COUNTIF(A1:A1000,"*")

 

[susanquinn]

Thank you all!

=COUNTIF(A1:A1000,"*") works in my spreadsheet as doe
=CountA(A1:A10)-Count(A1:A10) - although I didn't have to do th
-Count(A1:A10) portion as the only thing I would ever have in this lis
is students' names