00:00In Google Sheet, how do you add numbers in the cell that are comma separated?
00:03That was the question posted in my comment section recently.
00:07In my previous video, I demonstrated how you can achieve the same result in Excel,
00:11but now I'll show you how you can accomplish the same task in Google Sheet.
00:15Let's start off with the split function.
00:16The first argument will be B2, and the delimiter will be a comma.
00:20This function will essentially separate each number using a comma as a delimiter
00:24and stores them in an array.
00:26After that, we will encapsulate it with a sum function which calculates the total
00:30by adding up all the elements within the array.
00:33After that, apply the formula to all the rows, and voila, you're done.
Comments