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