Forum Discussion

jose cedeño's avatar
jose cedeño
Copper Contributor
Feb 13, 2018

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 ...
Formulas & Functions
Tutorial
jose cedeño's avatar
jose cedeño
Copper Contributor
Feb 13, 2018

Hi Damien, it seems to have something to do with the source I guess because I've tried everything already and wouldn't work. do you know how to change the confidence options, that's the only thing I haven't done yet.

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Feb 13, 2018

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

 

  • jose cedeño's avatar
    jose cedeño
    Copper Contributor
    Feb 13, 2018

    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

Resources