count number in column

[iamrony]

All<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o> </o>
Please help, I 'll count number in column <o></o>
Example <o></o>
A count is<o></o>
4, 10, 12, 16 4<o></o>
15, 2 2<o></o>
1 1<o></o>
<o> </o>
Hope you help!<o></o>
<o> </o>
Thank you <o></o>

 

[Stormseed]

Hi, welcome to MrExcel

I am sorry but I did not understand your question..what do you want to accomplish ?

1) Count only the numbers in a column which also contains text ?
2) You need a formula to count the numbers in a column ?
3) You want to count the numbers based on a criteria ?

 

[iamrony]

I'm sorry the example is mistake

Please see it again A column has value and I want to count position only figure.

Example <?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
A |count is
4, 10, 12, 16 | 4<o></o>
15, 2 | 2<o></o>
1 |1<o></o>
Yes,I need formula to count the numbers in a column.
Thank

 

[Stormseed]

No, you are still unclear or maybe I am a bit dumb to understand your question.

well, is this how your data looks like and is it that you want to count the numbers in the same cell ?

Book1
	A	B	C	D
1	4,10,12,16	4
2	15,2	2
3	1	1
Sheet1

EDIT:

and I want to count position only figure

You want to count the numbers or do you want to return the position of the numbers in the cell ?

 

[Aladin Akyurek]

I'm sorry the example is mistake

Please see it again A column has value and I want to count position only figure.

Example <?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
A |count is
4, 10, 12, 16 | 4<o></o>
15, 2 | 2<o></o>
1 |1<o></o>
Yes,I need formula to count the numbers in a column.
Thank

If A1 houses the string 4, 10, 12, 16, then...

B1:

=LEN(A1)-LEN(SUBSTITUTE(A1,",",""))+1

 

[Trebor76]

You should always make a note in your thread when you're cross posting!!

 

[iamrony]

Many thanks for all