Summing one cell

[Hansi]

How do I sum one cell, so that f.ex. the number 92745 from one cell is shown as the sum 27 (9+2+7+4+5), or even 9 (2+7)?

 

[Norman Harker]

Hi Hansi!

A Google search revealed that this was discussed at length in June:

See:
http://tinyurl.com/2aarf


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

How do I sum one cell, so that f.ex. the number 92745 from one cell

is shown as the sum 27 (9+2+7+4+5), or even 9 (2+7)?