counting text cells

[Guest]

Hi, I need to count the number of cells in a range that have text in the
cell. There are a number of blank cells that when I use the counta function
are included in the count. I don't want the blank cells counted. Any
suggestions?
Ex:
A1 contains 'oranges';A2 to A4 is blank; A5 contains 'apples'; A6 contains
'oranges' A7 contains 'pears'
I want the total in cell A8 to be 4.

 

[Jason Morin]

=SUMPRODUCT(--(LEN(A1:A7)>0))

HTH
Jason
Atlanta, GA

 

[Guest]

Thanks Jason, but this is still returning 7, what am I doing wrong??

 

[Aladin Akyurek]

=COUNTIF(A1:A7,"?*")

which excludes zero-length text values.

 

[Jason Morin]

It could be a number of things. Send me your file and
I'll take a look. Replace OPPOSITEOFCOLD with you know
what.

Jason