Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum all integers of a given number
Hi,
Is there an easy way to arrange a formula that will Sum all integers of a given number? such that when applied on colum A, the result will be B: 21 3 77 14 12345 15 1 1 321 6 thanks for you help, pchr |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum all integers of a given number
With
A1: (a number) This formula sums each digit in that number B1: =SUMPRODUCT(--MID(A1,ROW($A$1:INDEX($A:$A,LEN(A1),1)),1)) Example: A1: 123 B1 returns 6 Does that help? ------------ Regards, Ron Microsoft MVP (Excel) "pchr" wrote in message ups.com... Hi, Is there an easy way to arrange a formula that will Sum all integers of a given number? such that when applied on colum A, the result will be B: 21 3 77 14 12345 15 1 1 321 6 thanks for you help, pchr |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum all integers of a given number
Thanks for you help,
I'm currently using open office "calc" which has the same excel functions and I can't get it to work overthere On Jun 8, 5:37 pm, "Ron Coderre" wrote: With A1: (a number) This formula sums each digit in that number B1: =SUMPRODUCT(--MID(A1,ROW($A$1:INDEX($A:$A,LEN(A1),1)),1)) Example: A1: 123 B1 returns 6 Does that help? ------------ Regards, Ron Microsoft MVP (Excel) "pchr" wrote in message ups.com... Hi, Is there an easy way to arrange a formula that will Sum all integers of a given number? such that when applied on colum A, the result will be B: 21 3 77 14 12345 15 1 1 321 6 thanks for you help, pchr- Hide quoted text - - Show quoted text - |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum all integers of a given number
Regarding:
I'm currently using open office "calc" which has the same excel functions and I can't get it to work overthere Evidently, not exactly the same, though, right? If Open Office has a forum, that would be the place to ask the question. I hope that helps. *********** Regards, Ron XL2002, WinXP "pchr" wrote: Thanks for you help, I'm currently using open office "calc" which has the same excel functions and I can't get it to work overthere On Jun 8, 5:37 pm, "Ron Coderre" wrote: With A1: (a number) This formula sums each digit in that number B1: =SUMPRODUCT(--MID(A1,ROW($A$1:INDEX($A:$A,LEN(A1),1)),1)) Example: A1: 123 B1 returns 6 Does that help? ------------ Regards, Ron Microsoft MVP (Excel) "pchr" wrote in message ups.com... Hi, Is there an easy way to arrange a formula that will Sum all integers of a given number? such that when applied on colum A, the result will be B: 21 3 77 14 12345 15 1 1 321 6 thanks for you help, pchr- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rounding to Multiples of Integers? | Excel Discussion (Misc queries) | |||
Rotating through a range of integers | Excel Discussion (Misc queries) | |||
changing integers in a list | New Users to Excel | |||
A list of Consecutive Integers, can I search for missing integers | Excel Worksheet Functions | |||
converting to Integers | Excel Worksheet Functions |