## [Solved] Calculate difference between SUMs

### [Solved] Calculate difference between SUMs

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].
Last edited by robleyd on Wed Jan 22, 2020 1:34 pm, edited 1 time in total.
Reason: Tagged [Solved]
openoffice 4.1.6 on windows 10 x64
awstech

Posts: 2
Joined: Wed Jan 22, 2020 1:10 pm

### 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.

Code: Select all   Expand viewCollapse view
`=SUM(B18:L18) - SUM(B29:L29)`

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
Cheers
David
Apache OpenOffice 420m2(Build:9821) - Slackware 14.2 - 64 bit
LibreOffice 6.0.7.3 - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine

robleyd
Moderator

Posts: 3463
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

### Re: Calculate difference between SUMs

perfect thank you.
openoffice 4.1.6 on windows 10 x64
awstech

Posts: 2
Joined: Wed Jan 22, 2020 1:10 pm

### Re: [Solved] Calculate difference between SUMs

Alternatively you could use
Code: Select all   Expand viewCollapse view
`=sum(b18:l8;-(B29:l29))`
OpenOffice 4.1.7 and LibreOffice 6.3.3.2 on Windows 7 Pro & Ultimate
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.

RusselB
Moderator

Posts: 6117
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON