Adding money in cells in the same row

[pussycat]

I have a spreadsheet using 32 rows and 4 columns. All cells show a monetary value in Pounds. Columns A,B and C record my investment accounts and column D show the sum of columns A,B and C. Using the formula =SUM(A1,A2,A3) the correct addition is shown in column D for all 32 rows except three which shows only the amount of money in column A. I have double checked that the correct formula is entered in column D in the cells which are not showing the correct addition and I can't understand why the correct calculation is not made.

[SuperTech]

Thanks for posting your problem. Please share the file in which you are getting this problem so that we can check it.

If your file is private, please send it to forum[at]softmaker.com with the link of this post.