[Solved] Calculate difference between SUMs

Discuss the spreadsheet application
Post Reply
awstech
Posts: 2
Joined: Wed Jan 22, 2020 1:10 pm

[Solved] Calculate difference between SUMs

Post by awstech »

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

Re: need formula

Post by robleyd »

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

=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
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.1.2; SlackBuild for 24.2.1 by Eric Hameleers
awstech
Posts: 2
Joined: Wed Jan 22, 2020 1:10 pm

Re: Calculate difference between SUMs

Post by awstech »

perfect thank you.
openoffice 4.1.6 on windows 10 x64
User avatar
RusselB
Moderator
Posts: 6646
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: [Solved] Calculate difference between SUMs

Post by RusselB »

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