Apache OpenOffice Community Forum

Posted: **Wed Feb 16, 2022 6:21 am**

I have a value in A1.

I want to type in values in A2 through A30. Each value I type in, I want it to subtract from the value in A1. The total where it is calculated would be in A31.

Anyone that can help me figure out what the formula is?

Posted: **Wed Feb 16, 2022 7:07 am**

One solution if I understand your question correctly; in A31 put

Code: Select all

=A1-SUM(A2:A30)

Posted: **Wed Feb 16, 2022 9:13 am**

usmdesigner,

please upload your ODF type sample file here.

Posted: **Wed Feb 16, 2022 6:51 pm**

robleyd wrote:One solution if I understand your question correctly; in A31 put
Code: Select all
=A1-SUM(A2:A30)

Thanks! This worked perfectly!

Apache OpenOffice Community Forum

[Solved] How to subtract from 1 cell only

[Solved] How to subtract from 1 cell only

Re: How to subtract from 1 cell only

Re: How to subtract from 1 cell only

Re: How to subtract from 1 cell only