Learn how to sum, separated values in jagged format in Excel. <br /><br />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. <br /><br />This is a formula feature in my video. <br /><br />=SUM(--(TEXTSPLIT(B2,","))) <br /><br />Let's break down the formula. <br /><br />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"]. <br /><br />--: 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. <br /><br /><br />🔗🔗 LINKS TO SIMILIAR VIDEOS 🔗🔗 <br />Sum comma separated values in Excel - Excel Tips and Tricks <br />https://youtube.com/shorts/1GUx7zi2wzc?si=Rc8Oidvtr6t-dOFV <br /><br />Sum comma separated values in Excel Without Using TEXTSPLIT() Function - Excel Tips and Tricks <br />https://youtube.com/shorts/z6ghCP7G3ew?si=rIS6nZL31jA41g17 <br /><br />Separate data from one cell in Excel with commas - Excel Tip and Tricks <br />https://youtube.com/shorts/xuhpFwb5TWg?si=8YYj22Elb2Ez2rMp <br /><br />Text Split with multiple delimiters - Excel Tip and Tricks <br />https://youtube.com/shorts/LXZkMlGZWXQ?si=v-ovLGoZ2SdQ-baC <br /><br />[NO FORMULA] Separate data from one cell in Excel with commas - Excel Tip and Tricks <br />https://youtube.com/shorts/4AhokAuE5Nc?si=ObQffk0YBaj0SgyU <br /><br />Sum comma separated values in jaggered format in Excel - Excel Tips and Tricks <br />https://youtube.com/shorts/ijC7qhRK6s0?feature=share <br /><br />Get maximum of comma-separated values in a cell In Excel - Excel Tips and Tricks <br />https://youtube.com/shorts/UHdjAsSx6C8?feature=share <br /><br />Sum comma separated values in Google Sheets - Excel Tips and Tricks <br />https://youtube.com/shorts/bYOX6V_iWnI?feature=share <br /><br /><br />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?, <br /><br />Check out my complete suite of Microsoft Excel Tips and Tricks. <br />https://www.youtube.com/@jjnet247/shorts <br />https://www.tiktok.com/@exceltips247 <br />https://www.instagram.com/exceltips247/ <br />https://www.dailymotion.com/ExcelTips247 <br />https://www.pinterest.com/ExcelTips247/excel-tips-and-tricks/ <br />https://x.com/ExcelTips247/media <br />https://www.reddit.com/r/Excel247/ <br />https://www.facebook.com/XyberneticsInc/reels/ <br /><br />#microsoft #excel #tips #tipsandtricks #microsoftexcel #accounting #fyp #fypシ #exceltips #exceltricks
