Page 1 of 1

[Solved] How to subtract from 1 cell only

Posted: Wed Feb 16, 2022 6:21 am
by usmdesigner
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?

Re: How to subtract from 1 cell only

Posted: Wed Feb 16, 2022 7:07 am
by robleyd
One solution if I understand your question correctly; in A31 put

Code: Select all

=A1-SUM(A2:A30)

Re: How to subtract from 1 cell only

Posted: Wed Feb 16, 2022 9:13 am
by Zizi64
usmdesigner,

please upload your ODF type sample file here.

Re: How to subtract from 1 cell only

Posted: Wed Feb 16, 2022 6:51 pm
by usmdesigner
robleyd wrote:One solution if I understand your question correctly; in A31 put

Code: Select all

=A1-SUM(A2:A30)
Thanks! This worked perfectly!