Adding money in cells in the same row

Post Reply
pussycat
Posts: 2
Joined: Sun Jan 22, 2023 7:43 pm

Adding money in cells in the same row

Post by 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
SoftMaker Team
SoftMaker Team
Posts: 2930
Joined: Wed Mar 11, 2020 5:31 pm

Re: Adding money in cells in the same row

Post by 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.
Post Reply

Return to “PlanMaker 2021 for Windows”