Count cells with text

[newtoexcel111]

If have a formula in cells F1:F5 that is =IF(ISNUMBER(B1),A1,""). Saying that if B1 is a number than copy the name in cell A1 into cell F1. Now, where my problem lies is that I am trying to get another formula that counts only the cells with text in them and not the cells with formulas returning no answer. How can I do this?

 

[Aladin Akyurek]

If have a formula in cells F1:F5 that is =IF(ISNUMBER(B1),A1,""). Saying that if B1 is a number than copy the name in cell A1 into cell F1. Now, where my problem lies is that I am trying to get another formula that counts only the cells with text in them and not the cells with formulas returning no answer. How can I do this?

Try...

=COUNTIF(F1:F5,"?*")

Or directly:

=SUMPRODUCT(--ISNUMBER(B1:B5),--ISTEXT(A1:A5))

Caveat. A1:A5 must not house formula blanks (i.e., "").

 

[newtoexcel111]

Worked perfectly!!! Thanks!

 

[Aladin Akyurek]

Worked perfectly!!! Thanks!

You are welcome.