Excel Pro Trick: Sum Comma Separated Values in Excel with Formula using TEXTSPLIT + LAMBDA Function

Learn how to sum comma separated values or numbers separated by comma in a single cell in Excel using a simple to understand Excel formula.
In this Excel tutorial we learn how to use TEXTSPLIT function to sum comma separated values or numbers that are separated by a delimiter like comma, colon, semicolon etc. using Excel formula.
In addition to SUM and TEXTSPLIT function, we will also explore how to use MAP and LAMBDA functions to add comma separated values using array formulas without the need to drag the fill handle. LAMBDA function will automatically spill the totals for us in the column.
Lets Excel!
Access or download practice workbook file for this Excel tutorial:
1drv.ms/x/s!Ap...
For more Excel tips, tricks and tutorials don't forget to subscribe to ‪@LearnExceltoexcel‬ channel.
Learn #Excel your way:
===================
Website: learnexceltoex...
--------------------------------------
Pick your favourite social page:
Fb: bit.ly/3yM3dvd
Tiktok: bit.ly/3wFllpf
Tw: bit.ly/3wGCRYU
Pin: bit.ly/3NsjKIU
Yt: bit.ly/3wxKL8a
Insta: bit.ly/3wtT9oW
Music by: / ikson
#excelsum #excel #sumif #conditionalsum #conditionalsumexcel #exceltutorial #exceltips #excelformula #excelformulas #excelformulasandfunctions #excelformulaforjobinterview #excelformulatypes #excelsum #excelmap #lambda #excellambda #exceltextsplit