Count if?

  • Thread starter Thread starter susanquinn
  • Start date Start date
S

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.
 
how about counta(range) - countif(range,">0") to count # of cells with
nonnumeric entries?
 
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
 
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.
 
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
 
Back
Top