How to Sum Comma Separated Values in Cell in Excel in Hindi

Sum Comma Separated Values in Cell in Excel in Hindi
One common problem that an Excel user might face while trying to sum comma-separated values in a cell is that the values may not be recognized as numbers by Excel, resulting in errors or incorrect results.

When a user tries to sum comma-separated values, Excel may treat them as text instead of numerical values. This can cause problems because Excel cannot perform mathematical calculations on text strings.

One of the most common tasks in Excel is to sum values in a cell. If you have a list of comma-separated values in a cell and want to find the sum of those values, This can be achieved by using the SUM function and the Textsplit function.

To begin with, select the cell that contains the comma-separated values you want to sum. Next, click on the formula bar and type "=SUM(--(TEXTSPLIT(cell reference,",")))" and press enter. The TEXTSPLIT function is used to separate the values into individual cells, and the SUM function is used to add up those values.

For example, if the comma-separated values are in cell A1, the formula will look like "=SUM(--(TEXTSPLIT(cell reference,",")))". This will give you the sum of all the values in the cell.

It's important to note that the Textsplit function is only available in newer versions of Excel, such as Excel 2013 or later. If you're using an older version of Excel, you can still achieve the same result by using the Text to Columns feature.

In conclusion, summing comma-separated values in Excel can be easily done using the SUM and Textsplit functions. This technique can save you a lot of time and effort when dealing with large datasets. With a little bit of practice, you'll be able to sum comma-separated values in no time!

Download Practice Files from

** Useful Excel formulas and Functions **

[ariesaakash]

Salesman hulk 😂😂❤
Btw, good to have u back after a long time, your voice is really blessed soothing 👌

[elururameshkumar]

Can you please let me know how to use xlookup in Google sheets and reverse vlookup in Google sheets

[gauravkapoor]

Sir ji ..textsplit ka to formula show h nhi hota to kase hoga ..😅..yeah formula excel main hai h nhi ..

[ashujoshi]

thanku, process accha h but kuch lamba h

[md.saleem]

Sir if we have only digits not comma

Kese kr skte hai sum like 12345=15

Please help