How to Enter a formula for column subtraction ?

General discussion on OpenOffice Calc and its spreadsheets.

How to Enter a formula for column subtraction ?

Postby Joseph S. Klein » Sat Sep 27, 2014 5:50 am

Hello,

I am trying to enter a formula for the following scenerio. Line 3 has total cash available. Lines 4 through 10 have expenses to be subtracted from line 3. The answer needs to go on line eleven. I know how to click on line 11 and then go up and click the sum button. But then I do not know what to enter on the input line. :( I hope i have made this clear enough to be understood!

Thanks in advance for your help.
Joseph S. Klein
 
Posts: 38
Joined: Mon Mar 24, 2014 6:28 am

Re: How to Enter a formula for column subtraction ?

Postby Ricky G. Marion » Sat Sep 27, 2014 10:57 am

Hello,

Please try this formula:
Code: Select all
=C3 - SUM(C4:C10)

if your data are in column C.
Ricky G. Marion
 
Posts: 25
Joined: Mon Mar 24, 2014 6:33 am


Return to OpenOffice.org Calc

Who is online

Users browsing this forum: No registered users and 2 guests

cron