Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count numbers in the same cell
I need to know how many numbers are in the same cell.
Example: A1 inculdes 12,23,34,45 How I calculating this numbers(Answer:4)? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count numbers in the same cell
For comma separated values
=LEN(A1)-LEN(SUBSTITUTE(A1,",",""))+1 If this post helps click Yes --------------- Jacob Skaria "backmara" wrote: I need to know how many numbers are in the same cell. Example: A1 inculdes 12,23,34,45 How I calculating this numbers(Answer:4)? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count numbers in the same cell
Basically, you count the commas and add one. This will do it:
=LEN(A1)-LEN(SUBSTITUTE(A1,",",""))+1 Hope this helps. Pete On May 22, 11:47*am, backmara wrote: I need to know how many numbers are in the same cell. Example: A1 inculdes 12,23,34,45 How I calculating this numbers(Answer:4)? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count numbers in the same cell
Thanks gyus;
this works: =LEN(A1)-LEN(SUBSTITUTE(A1;",";""))+1 "backmara" kirjoitti: I need to know how many numbers are in the same cell. Example: A1 inculdes 12,23,34,45 How I calculating this numbers(Answer:4)? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count numbers in the same cell
I'd use:
=LEN(A1)-LEN(SUBSTITUTE(A1,",",""))+(A1<"") The (A1<"") will only add 1 if a1 is not empty. backmara wrote: I need to know how many numbers are in the same cell. Example: A1 inculdes 12,23,34,45 How I calculating this numbers(Answer:4)? -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count numbers in the same cell
=IF(A1="",0,LEN(A1)-LEN(SUBSTITUTE(A1,",",""))+1)
If this post helps click Yes --------------- Jacob Skaria "Jacob Skaria" wrote: For comma separated values =LEN(A1)-LEN(SUBSTITUTE(A1,",",""))+1 If this post helps click Yes --------------- Jacob Skaria "backmara" wrote: I need to know how many numbers are in the same cell. Example: A1 inculdes 12,23,34,45 How I calculating this numbers(Answer:4)? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I count just the numbers in a cell, no spaces or comas? | Excel Worksheet Functions | |||
Count numbers of Month in a cell | Excel Worksheet Functions | |||
Function to count numbers in one Cell IE 1+2+10 | Excel Worksheet Functions | |||
How do I add/count numbers in the same cell in excel worksheet? | Excel Worksheet Functions | |||
can you perform a character count per cell with numbers? | Excel Discussion (Misc queries) |