Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|