adding numbers in each cell
 

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?

adding numbers in each cell
 

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


"Jeff" wrote:

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?

adding numbers in each cell
 

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,",",""))

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Jeff" wrote in message
...
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?