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 just noticed that it's not recognicing any of the values as numbers. I uploaded 2 pics to show what I'm trying to explain.shows column D with valuesShows the error and blank spaces as 0
5 Replies
Hi Jose
Thanks for the screen shots, it helps to see the problem!
From your first image, it appears that your Debito column is Text, therefore the SUM formula will not work.
Can I suggest the following:
- Select columns D and E.
- In the Home tab under the Number section, drop down the list and select Currency.
- Both columns should now reflect $ currency values and your SUM formula (e.g. =SUM(D2:D13)) should work now.
See if this works for you?
I've also attached a sample file for you to see the formula and format in action, so you can have a play with it if you want.
Please let us know how you go.
Cheers
Damien
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.
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
