Have a Question?

If you have any question you can ask below or enter what you are looking for!



Excel-

How to get the sum of 1,2 and 3 in (1-2-3)?

  Rupesh Kumar

Suppose (1-2-3) is in cell A1 then in B1 put the below formula

SUM(IFERROR(MID(A1,ROW($A$1:INDEX(A:A,LEN(A1))),1)+0,""))

Note: acknowledge the formula with CTRL + SHIFT + ENTER and not just simple ENTER.

Execution:

1) Go to cell B1

2) Type = sign

3) Paste the above formula

4) HIT CTRL + SHIFT + ENTER together

You may also follow the below link to understand the implementation of array formula

http://www.cpearson.com/excel/arrayformulas.aspx

  Asheesh Mattoo       19 Jul 2016       1       0     

Post Your Answers:

Please use the CODE HIGHLIGHT Button to format/highlight your codes if any