| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum of a number's digits
Hi Kostis,
Didn't notice you in there. Got the details, digesting it now thanks. Unfortunately time is marching on. Regards Bob "vezerid" wrote in message ups.com... Bob, can always count on you for a new idea... Regards, Kostis Bob Phillips wrote: =SUMPRODUCT(--(MID(SUBSTITUTE(A1,".",""),ROW(INDIRECT("1:"&LEN(S UBSTITUTE(A1 ,".","")))),1))) -- HTH Bob Phillips |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| in excel, how to limit digits of negative hexadecimal numbers? | Excel Discussion (Misc queries) | |||
| counting digits, not numbers | Excel Worksheet Functions | |||
| Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
| Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
| Converting Numbers to Text properly | Excel Discussion (Misc queries) | |||
Threaded Mode
