00:00Couple of minutes ago someone came to my desk and asked me how do you add all
00:03these numbers here that is actually separated by a comma. This is how you do
00:07it. First you're gonna have to split this cell value into an array. You're gonna
00:11use a function called textSplit and then the first argument on the textSplit
00:17will be the cell where the numbers are comma and the second argument is your
00:22delimiter which is your comma itself and this will create an array of numeric
00:28value which is in string. To convert them you're gonna have to use a double dash
00:33which is also known as a double unary operator which basically converts the
00:37string of numbers into actual numbers where you can do math. Once that's done
00:43you use the good old sum function and then you are done for that row. So after
00:50that to apply to all the row just drag on this handler and then you are done.
Comments