hi, im new so be gentle with me, I need a formula for the following, =SUM(B18:L18-B29:L29) I have also tried =SUM(B18:L18)-(B29:L29) this would be the total of B18 to L18 minus the total of B29 to L29
thanks.
Title Edited. A descriptive title for posts helps others who are searching for solutions and increases the chances of a reply [robleyd, Moderator].
[Solved] Calculate difference between SUMs
[Solved] Calculate difference between SUMs
Last edited by robleyd on Wed Jan 22, 2020 1:34 pm, edited 1 time in total.
Reason: Tagged [Solved]
Reason: Tagged [Solved]
openoffice 4.1.6 on windows 10 x64
Re: need formula
So what you want is the value of the sum of B18:L18 minus the value of the sum of B29:L29 ? Use two SUMs to get the two values and subtract the one from the other.
If you are new to spreadsheets, you may find the following to be useful resources.
[Tutorial] Ten concepts that every Calc user should know
OpenOffice Spreadsheet Tutorial for Beginners with Examples
Code: Select all
=SUM(B18:L18) - SUM(B29:L29)
[Tutorial] Ten concepts that every Calc user should know
OpenOffice Spreadsheet Tutorial for Beginners with Examples
Cheers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.1.2; SlackBuild for 24.2.1 by Eric Hameleers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.1.2; SlackBuild for 24.2.1 by Eric Hameleers
Re: [Solved] Calculate difference between SUMs
Alternatively you could use
Code: Select all
=sum(b18:l8;-(B29:l29))
OpenOffice 4.1.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.