Simple subtraction

Discuss the spreadsheet application
Post Reply
tbrownarcher
Posts: 1
Joined: Thu Oct 12, 2017 9:49 pm

Simple subtraction

Post by tbrownarcher »

I have a column of numbers added and the total in a cell. how do i calculate the total of that cell minus the number in another cell another cell ?
Last edited by tbrownarcher on Thu Oct 12, 2017 10:33 pm, edited 1 time in total.
OpenOffice 4.1.2 on windows 10
Top
FJCC
Moderator
Posts: 9278
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Simple subtraction

Post by FJCC »

If you want to sum the cells A1 through A10 and then subtract the value in B1, the formula is

Code: Select all

=SUM(A1:A10) - B1
Is that what you need?
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Top
Post Reply

Return to “Calc”