Formula

[Dan Cotton]

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?

 

[Pete_UK]

Try this:

=COUNTIF(A1:A5,"*w*")

You can use wildcards with COUNTIF.

Hope this helps.

Pete

 

[Dan Cotton]

Thank you so much. That was right on the money.

 

[Pete_UK]

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

Pete