Sum multiple numbers in 1 cells in Excel

such as a1=3779, 3759, 3769, 3781, 3750,a2 to A1 in the sum of 4 numbers how to beg! Please enlighten the master!

Method three: Solve with VBA. Enter the VBE editing environment, insert the module, enter the code:
Function cell sum (i as Range)
    Cell summation = Application.evaluate (Worksheetfunction.substitute (i, ",", "+"))
End Function
Go back to the table you just entered in B1 = Cell sum (A1) to get the results you want.

All numbers in multiple cells are added divided by percentages:
= (EVALUATE (Substitute ($C 2, ",", "+")) +evaluate (Substitute ($C 3, ",", "+")) +evaluate (Substitute ($C 4, ",", "+"))) *24%

Sum multiple numbers in 1 cells in Excel