Formula
Try this:
=COUNTIF(A1:A5,"*w*")
You can use wildcards with COUNTIF.
Hope this helps.
Pete
On Sep 2, 1:26*am, Dan Cotton
wrote:
This may seem stupid but here it goes. I have excel 2003 on my computer. I
know how to get the sum say line 6 = line 1-5 with numbers. My question is
how to get the sum in nunbers for line 6 counting letters on lines 1-5.
Example line 1-5 has a w in each box, how do I get a number 5 in colum 6?
--
Thanks, Dan
|