Formula
 

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

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

Formula
 

Thank you so much. That was right on the money.
--
Thanks, Dan


"Pete_UK" wrote:

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

Formula
 

You're welcome, Dan - thanks for feeding back.

Pete

On Sep 2, 2:25*am, Dan Cotton
wrote:
Thank you so much. That was right on the money.
--
Thanks, Dan



"Pete_UK" wrote:
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- Hide quoted text -

- Show quoted text -