Hmm, the Evaluate did not work for me. I think the problem is that the numbers are stored as text, and show the German number format with a decimal comma and a dot as the thousand separator. In that format, Excel does not recognise the numbers when the regional settings have different delimiters.
The following UDF can calculate the sum of the values represented by the text. First, the dot is removed from the text, then the decimal comma is replaced with a decimal point. Then the text gets converted to numbers and is summed.
There are probably slicker ways of coding this, but I'm no VBA whiz.
The code goes into a standard module. Then, in the spreadsheet use it with this syntax:
=textsum(A1:A10)
Let me know if this works for you.
Bookmarks