Sum comma separated values in jaggered format in Excel - Excel Tips and Tricks

Learn how to sum, separated values in jagged format in Excel.

In Excel, summing values separated by commas can be achieved by first using the TEXTSPLIT function to split the comma-separated values into an array of individual numbers, and then using the SUM function to add them up. To fix comma-separated values in Excel, you can utilize the TEXTSPLIT function to split the values into separate cells, allowing you to manipulate them individually.

This is a formula feature in my video.

=SUM(--(TEXTSPLIT(B2,",")))

Let's break down the formula.

TEXTSPLIT(B2,","): This function splits the text in cell B2 into an array of substrings, using the comma (",") as the delimiter. So, if B2 contains something like "10,20,30", it will split it into an array like ["10", "20", "30"].

--: This is a double unary operator. It is used to convert the values in the resulting array from the TEXTSPLIT function into numeric values. The first unary operator converts the text values into numbers, and the second unary operator does it again.


🔗🔗 LINKS TO SIMILIAR VIDEOS 🔗🔗
Sum comma separated values in Excel - Excel Tips and Tricks
https://youtube.com/shorts/1GUx7zi2wzc?si=Rc8Oidvtr6t-dOFV

Sum comma separated values in Excel Without Using TEXTSPLIT() Function - Excel Tips and Tricks
https://youtube.com/shorts/z6ghCP7G3ew?si=rIS6nZL31jA41g17

Separate data from one cell in Excel with commas - Excel Tip and Tricks
https://youtube.com/shorts/xuhpFwb5TWg?si=8YYj22Elb2Ez2rMp

Text Split with multiple delimiters - Excel Tip and Tricks
https://youtube.com/shorts/LXZkMlGZWXQ?si=v-ovLGoZ2SdQ-baC

[NO FORMULA] Separate data from one cell in Excel with commas - Excel Tip and Tricks
https://youtube.com/shorts/4AhokAuE5Nc?si=ObQffk0YBaj0SgyU

Sum comma separated values in jaggered format in Excel - Excel Tips and Tricks
https://youtube.com/shorts/ijC7qhRK6s0?feature=share

Get maximum of comma-separated values in a cell In Excel - Excel Tips and Tricks
https://youtube.com/shorts/UHdjAsSx6C8?feature=share

Sum comma separated values in Google Sheets - Excel Tips and Tricks
https://youtube.com/shorts/bYOX6V_iWnI?feature=share


How do I sum values separated by commas in Excel?,How do I fix comma-separated values in Excel?,How do I count unique values separated by commas in Excel?,How do I combine comma-separated values in Excel?,

Check out my complete suite of Microsoft Excel Tips and Tricks.
https://www.youtube.com/@jjnet247/shorts
https://www.tiktok.com/@exceltips247
https://www.instagram.com/exceltips247/
https://www.dailymotion.com/ExcelTips247
https://www.pinterest.com/ExcelTips247/excel-tips-and-tricks/
https://x.com/ExcelTips247/media
https://www.reddit.com/r/Excel247/
https://www.facebook.com/XyberneticsInc/reels/

#microsoft #excel #tips #tipsandtricks #microsoftexcel #accounting #fyp #fypシ #exceltips #exceltricks