[Solved] Calculate difference between SUMs

Discuss the spreadsheet application

[Solved] Calculate difference between SUMs

Postby awstech » Wed Jan 22, 2020 1:15 pm

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

Postby robleyd » Wed Jan 22, 2020 1:22 pm

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
User avatar
robleyd
Moderator
 
Posts: 3463
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Calculate difference between SUMs

Postby awstech » Wed Jan 22, 2020 1:30 pm

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

Postby RusselB » Wed Jan 22, 2020 5:05 pm

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.
User avatar
RusselB
Moderator
 
Posts: 6117
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON


Return to Calc

Who is online

Users browsing this forum: calculateur and 20 guests