formula.

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

--
Motilull
-----------------------------------------------------------------------
Motilulla's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3715
View this thread: http://www.excelforum.com/showthread.php?threadid=56878

Dave
Sun Aug 06 13:15:30 CDT 2006

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

Motilulla wrote:
>
> Hello,
>
> I'm in need for a formula, if in cell A for example i introduce number
> 2 and in cell B number 3, cell C would give me a total of 5. But if for
> example i write '23' in the same cell (a) i want cell b to give me a
> 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.
>
> --
> Motilulla
> ------------------------------------------------------------------------
> Motilulla's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=37159
> View this thread: http://www.excelforum.com/showthread.php?threadid=568780

--

Dave Peterson

Motilulla
Sun Aug 06 19:22:01 CDT 2006


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


--
Motilulla
------------------------------------------------------------------------
Motilulla's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=37159
View this thread: http://www.excelforum.com/showthread.php?threadid=568780

daddylonglegs
Sun Aug 06 19:33:58 CDT 2006


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

--
daddylongleg
-----------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3048
View this thread: http://www.excelforum.com/showthread.php?threadid=56878

Motilulla
Sun Aug 06 19:48:19 CDT 2006


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


--
Motilulla
------------------------------------------------------------------------
Motilulla's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=37159
View this thread: http://www.excelforum.com/showthread.php?threadid=568780

daddylonglegs
Sun Aug 06 19:55:49 CDT 2006


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

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


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30486
View this thread: http://www.excelforum.com/showthread.php?threadid=568780

Motilulla
Sun Aug 06 20:06:14 CDT 2006


Dear, daddylonglegs

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

Thank You Very Much
Mot

--
Motilull
-----------------------------------------------------------------------
Motilulla's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3715
View this thread: http://www.excelforum.com/showthread.php?threadid=56878