OK, there is more. Even though the sum if of numbers with only two decimal places, the sum itself is 8805.13000000001 !!!
So the only way I can get a correct result is by using TRUNC(SUM(G2:G261),2).
Weird, as I have several worksheets all very similar, but only this one produces this odd result.
Thanks Bill!!!
|