formula.

M

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
 
M

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
 
D

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
 
M

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
 
D

daddylonglegs

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

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

Motilulla

Dear, daddylonglegs

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

Thank You Very Much
Mot
 
Top