Forum Discussion
Calculate simple equation which is included in one cell..
All cells in the Column contain more than one value in each cell , that they were entered by using Alt+enter .. I want a formula to sum the values in each Cell .. Exmp. the Cell A1 contains 100 20...
thank you very much , could you please send me it in Excel ..
Attached
It is not working fine , I tried different values like 100 1600 2000 in the cell it gave me value 1900 ..
Please expand your range in formula, e.g. use 100 instead of 10, like
...,REPT(" ",100)),{1,2,3,4,5,6,7,8}*100-99,100))
instead of
...,REPT(" ",10)),{1,2,3,4,5,6,7,8}*10-9,10))
When you'll have 3700 for "100 1600 2000". This magic 100 (or whatever) shall be more than maximum number of characters in any of your cells.