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


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


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


  Asheesh Mattoo       19 Jul 2016       1       0     

Post Your Answers:

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