Home » Forums » Open Source Learning Center » Question and Answer

Sum value in cell

Submitted by Kalop on 12 October, 2013 - 10:13

In cell A1 I have value of 225
What formula to enter in cell A2 to get as result 9 (2+2+5)

‹ Making fancy automatic graph Fetch Data automatically in a single cell ›
»

Hi there

Submitted by Jon on 12 October, 2013 - 16:28.

I think this is what you're looking for:

http://wikisend.com/download/673930/Book1.xlsx

The formula in cell A2 is an "array formula" and it be used to sum the digits of any number in A1 no matter how many digits the number has

Hope this helps

Jon

 

»

My 2 cents of contribuition

Submitted by Mr.Lobao on 12 October, 2013 - 15:36.

.
Kalop, Good afternoon.

For a fixed three digits number you may use this formula.
A2 --> =LEFT(A1,1)+MID(A1,2,1)+RIGHT(A1,1)

But if you have a variable digits number you must use this formula with a conditional variant.

Is it what you want?
I hope it helps.

Best regards,
-----------------------------------
Belo Horizonte, Brasil
Marcílio Lobão

»

Maybe the following and

Submitted by Kevin@Radstock on 27 October, 2013 - 18:32.

Maybe the following and assuming A1 contains 225.

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

»