Multiple Numerical Values in a Single Cell

[Olgethorpe]

Hi there, I'm fairly new to excel and I'm trying to find a way where I can enter multiple numerical values in a cell and then use the =SUM() function in order to add up all the values in a column. The amount of actual values do vary from cell to cell, and there could be empty cells between these values. I barely know how to use VBA, compiling and saving are not a problem but the actually coding is. Is there any feasible solution to the problem. I want to use a comma as a separator or something else if larger numerical values appear because there are thousands and such. Thank you very much for any help and have a nice day!Book2 - Copy.xlsx

[mehmetcik]

I have created a User Defined Function for you.

You can see how to use it in cell C33.

I cannot post the code today. I will try to do so tomorrow.

[Olgethorpe]

Thank you so much for your help I really appreciate it!

[FDibbins]

Hi there, I'm fairly new to excel and I'm trying to find a way where I can enter multiple numerical values in a cell and then use the =SUM() function in order to add up all the values in a column.

My advice would be to put each value in it's own cell...that is the way excel is designed to work.