I would like to total up all values/cells of a specific column and store the sum in a variable to keep on working with it.

So far I implemented this:

String_var = excel_original.AsEnumerable.Sum(Function(x)Convert.ToDecimal(x(10))).ToString

The problem is that this code does not consider the commas which are the decimal separators.

So in the case below

1,5

2,5

3

2,5

3,5

… the result should actually be 13. But it’s 130 since the comma is not considered.

Can someone please help?