formula.

[Motilulla]

Hello,

I'm in need for a formula, if in cell A for example i introduce numbe
2 and in cell B number 3, cell C would give me a total of 5. But if fo
example i write '23' in the same cell (a) i want cell b to give me
total of 5, so even if a write 53 it has to count it separately 5+3=8
can you please help me with this formula, as i'm badly stuck with it.

thank you
waiting eagearly
Moti

 

[Dave Peterson]

=SUMPRODUCT(--MID(A1,ROW(INDIRECT("1:" &LEN(A1))),1))

 

[Motilulla]

Dave Peterson
If I Write In Cell A1 Number 25 & Write Fourmula You Give Me In Cell
B1
I Get Result (#¿NOMBRE?) Not The Answer 7 What I want

Thanks
Motilulla

 

[daddylonglegs]

It works for me.

NOMBRE (NAME) error normally means one of the functions has not bee
recognised. Have you spelt everything correctly? Are you using Englis
version of Excel or Spanish

 

[Motilulla]

daddylonglegs

I am using Spanish version of Excel & I Have Tranleted Formula As Below
But Do Not work

=SUMAPRODUCT0(--EXTRAE(A1;FILA(INDIRECT0("1:" &LARGO(A1)));1))

Please Check Any Wrong Translation In Formula So it Not Working

Thanks
Moti

 

[daddylonglegs]

Make sure you have letter "O" not numero 0 in SUMPRODUCTO and INDIRECTO

=SUMAPRODUCTO(--EXTRAE(A1;FILA(INDIRECTO("1:" &LARGO(A1)));1))

 

[Motilulla]

Dear, daddylonglegs

You were Write In Both It was Number 0 Correcting With Letter O I
Works

Thank You Very Much
Mot