Discover how to sum comma separated values in Excel. Essentially, the answer to how to sum numbers with commas in a single Excel cell. Or how to sum numbers with commas in a single Excel cell? br br By using this formula. br br =SUM(--(TEXTSPLIT(B2,","))) br br Here's how the formula works: br br TEXTSPLIT(B2,","): This function splits the text in cell B2 into separate values based on the comma delimiter. For example, if cell B2 contains the text "10,20,30", the TEXTSPLIT function will return an array of three values: {"10","20","30"}. br br --(TEXTSPLIT(B2,",")): The double unary operator ("--") is used to convert the text values in the array to numeric values. If the values in the array cannot be converted to numbers, the result will be an error value. In our example, the result of this part of the formula would be an array of numeric values: {10,20,30}. br br SUM(--(TEXTSPLIT(B2,","))): The SUM function then adds up the numeric values in the array and returns the total sum. In our example, the result would be 60 (i.e., the sum of 10, 20, and 30).