ISTEXT

  • Thread starter Thread starter Guest
  • Start date Start date
One. However you could evaluate multiple cells in a range with one formula.
For example:

=SUMPRODUCT(--ISTEXT(A1:A10))

will evaluate each cell in A1:A10. The formula results in a total count of
cells in A1:A10 that contain text strings.

HTH
Jason
Atlanta, GA
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with nested if/or statements 8
lil help with "or" formula 5
IF AND ISTEXT ISBLANK formula 5
Blank cell not really blank 10
countif 13
Column fill first 5
complex IF(OR(...AND())) statement 2
numbers, text 1

Back
Top