Forum Discussion
Sum returns 0 and seems not to recognice the value.
I'm trying to sum some values on a worksheet, I downloaded the info from internet and it would allow me to change the info but whe I do the automated sum it woul give either 0 or an error and also I ...
It looks like unprintable characters are columns since the source is copy/pasted from internet, e.g.
228.20&CHAR(10) in D3.
If so array formula
=SUM(IFERROR(VALUE(CLEAN(D6:D93)),0))
could help
Hello, at least now with the clean function it shows numbers but still giving me back error and since the formula state if error is 0 turns everything in 0.here is the formula is in spanish but I'm sure the functions are correctshowing the valuesshowing the error
Hi Jose,
What is the decimal separator in your locale, dot or comma? Based on link below it shall be comma for Spanish locale, but your numbers are with dots.
https://docs.oracle.com/cd/E19455-01/806-0169/overview-9/index.html