Count Cell w/ Any text

S

Surf

Hi all,
How do I count cels that contain any text? I just want to
count the number of occurences. For example, I would like
to count the number of sales calls made. I would like the
total to appear in cel B7.
Example...

col A col B

r1 Sales Calls
r2 Mr Smith
r3 Ms Jones
r4 Mr Wills
r5 Mr Adams
r6
r7 Total calls: ?

Thanks
 
D

Dave R.

You can try this. It will be accurate as long as there are not text strings
like "" within any of those cells (e.g. as formula results).

=SUMPRODUCT(--ISTEXT(A2:A6))

=COUNTA(A2:A6)
is another alternative, though that would count cells containing numbers as
well.
 
Top