[Solved] Error in simple sum

Discuss the spreadsheet application

[Solved] Error in simple sum

Postby Clarky64 » Tue Feb 25, 2020 1:37 pm

This sheet has three columns .

Column L has this formula =SUM(J18+K18) =SUM(J19+K19) =SUM(J20+K20) etc

Column M has no formula and is where data is entered

Column N has this formula =SUM(L18)-M$5:M18, =SUM(L19)-M$5:M19, =SUM(L20)-M$5:M20

Everything is fine except column N which subtracts the cell the day the data is entered but following day column N is ignored and the figure entered previous day is not even taken into account.

Here is the sheet causing the problem :(
Attachments
EDF for upload.ods
Here is the sheet causing the problem
(81.21 KiB) Downloaded 61 times
Last edited by Clarky64 on Tue Feb 25, 2020 8:22 pm, edited 2 times in total.
Libreoffice 6.3, Manjaro Linux
Clarky64
 
Posts: 5
Joined: Tue Feb 25, 2020 12:49 pm

Re: Error in simple sum, please help.

Postby FJCC » Tue Feb 25, 2020 3:56 pm

I am not sure I follow the logic of your calculation but I believe you want your formula in N5 to be
Code: Select all   Expand viewCollapse view
=L5-SUM($M$5:M5)

As you copy that down it will become
Code: Select all   Expand viewCollapse view
=L6-SUM($M$5:M6)

in the next row and give you the difference between the running sum in column L and the running sum of column M.
As a side note, using expressions like SUM(L5) is unnecessary. That returns the value of L5 and accomplishes no more than you get from simply writing L5.
Windows 10 and Linux Mint, since 2017
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
FJCC
Moderator
 
Posts: 7752
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Error in simple sum, please help.

Postby Clarky64 » Tue Feb 25, 2020 8:20 pm

That works thank you.
Libreoffice 6.3, Manjaro Linux
Clarky64
 
Posts: 5
Joined: Tue Feb 25, 2020 12:49 pm


Return to Calc

Who is online

Users browsing this forum: RPG and 22 guests