The digits could change at any time I was looking at find but I'm not sure
how to get it to find anything but the first instance.

"Michael" wrote:

The sercond value should read A2 not A!, then you will have to adjust it for
the next set of values.
=SUM(VALUE(MID(A1,1,2)),VALUE(MID(A2,1,2)))
--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"Michael" wrote:

The Numbers you have is a string isn't it?
You could try something like this:
=SUM(VALUE(MID(A1,1,2)),VALUE(MID(A1,1,2)))
Granted in my example the number of digits is always 2; how often will the
numbers change? you can substitute the Last Parameter for a Find, searching
for a comma.
--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"Kevin" wrote:

Range A1= 15,10,1,8,1,9,0,1
Range A2= 15,10,1,8,1,9,0,1

I need 8 different formulas for A3-A10 to get the sum of each position.
So A3 would only get the sum of the first number in A1 and A2 (30)
A4 would get the sum of the second number in A1 and A2 (20)
A5=2
A6=16
A7=2
and so on...

Is that do-able?

Thanks,
Kevin