adding numbers in each cell

J

Jeff

I want to add the numbers in each cell by how many numbers appear.
For example: 1,2,5 would equal 3. Is there a way to do this?
 
K

Kevin B

Use =COUNT(A1:A30) to count cells with values, substituting A1:A30 with the
appropriate range address.
 
R

RagDyer

Are you saying that you want to sum the total number of individual numbers
in a particular cell?

If they are displayed *exactly* the same as in your example, just count the
commas and add 1:

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