# count number in column

#### iamrony

##### New Member
All<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<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>

### Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

#### Stormseed

##### Banned
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

##### New Member
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

##### Banned
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
ABCD
14,10,12,164
215,22
311
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 ?

Last edited:

##### MrExcel MVP
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

##### Well-known Member
You should always make a note in your thread when you're cross posting!!

#### iamrony

##### New Member
Many thanks for all

Replies
11
Views
1K
Replies
3
Views
138
Replies
0
Views
294
Replies
18
Views
377
Replies
5
Views
246

1,191,134
Messages
5,984,864
Members
439,921
Latest member
Neocold

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back