Summing individual digits in a cell

[rttaksali]

Hi there,

I want a formula to add the digits of a cell e.g. 1234, the total
would be 10, tried this forumla
'SUM(1*MID(A2,ROW(INDIRECT("1:"&LEN(A2))),1))' and resulted in answer
'1'.

Please, help, i am in urgent need.

Thanks

Rashi

 

[Frederik]

Have a look at

http://excel.tips.net/Pages/T002424_Summing_Digits_in_a_Value.html

Success!!!

 

[Frederik]

Or ...

http://support.microsoft.com/kb/214053

or

http://www.exceltip.com/st/Sum_the_...stom_VBA_function_in_Microsoft_Excel/620.html

Success!!!

 

[rttaksali]

Thanks..... very much... It worked......

Have a look at

http://excel.tips.net/Pages/T002424_Summing_Digits_in_a_Value.html

Success!!!

--
met vriendelijke groetjes

(e-mail address removed)
<[email protected]> schreef in bericht





- Show quoted text -

 

[Chip Pearson]

Rashi,

The formula you refer to is an array formula, so you *must* press CTRL
SHIFT ENTER rather than just ENTER when you first enter the formula
and whenever you edit it later. If you do this correctly, Excel will
display the formula enclosed in curly braces { }. For lots more
information about array formulas, see
http://www.cpearson.com/Excel/ArrayFormulas.aspx

Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
The San Diego Project Group, LLC
(email is on the web site)
USA Central Daylight Time (-5:00 GMT)