Hi all,

I'm trying to calculate the sum of 10 cells of values. They are all numbers, not text, and all set to AutoCalculate. I have also copied and pasted the values into a new column and retyped the same formula and still getting the wrong sum.

The sum should be $9021.28 but it keeps showing up at $9021.32. I have triple checked that each value is correct. I tried setting all the cells to ROUNDDOWN but that's not working and I'm wondering if that's what's tripping up the sum.

I'm a complete beginner at this so any help is much appreciated.