Counting text cells

[OakmontBob]

To do the above I tried the following: =sum(ISTEXT(G5:G177),1)) I got this from John Walkenbach's formulas book but it's not working - can anyone tell me what's wrong?

[OakmontBob]

correction the formula s/r =sum(if(ISTEXT(G5:G177),1))

[Richard Schollar]

Hi

I think that would need to be:

=SUM(ISTEXT(G5:G177)*1)

and confirmed with Ctrl+Shift+Enter

An alternative to count text cells with at least one character entered into it would be:

=COUNTIF(G5:G177,"?*")

normally entered.

Richard

[OakmontBob]

Richard - the =COUNTIF(G5:G177,"?*") did it - thank you very very much