Minus AutoSum

[Emanuel Vella]

Hi,

I know how to select cells and make a plus autosum (ex: 200 + 100 + 100 =
400). But I don't know how to make a minus autosum. (ex: 200 - 100 - 50 =
50).

Any help please?

Thanks in advance.

 

[Jean-Guy]

Hi,

How about:

=A1-A2-A3

or

=200-100-50

Cheers!
Jean-Guy

 

[Joel]

Try this

=200 - 100 - 50
=200 - (100 + 50)
Sum all memeber except the 1st. then subtracr from 1st member

=A1-(sum(A2:A100))

 

[Emanuel Vella]

Hi and thanks for the replies.

What I do is, I select for example A1, A2, A3, A4, A5 then I click on
formulas / autosum and it writes down automatically the answer in A6. But I
can do only the plus, now I want to do this with minus as well!

 

[Jean-Guy]

Hi,

Just don't see how that would be possible, consider this, you have 100 in
cell A1 and 50 in cell B1, now if you add A1+B1 you get 150, if you add B1+A1
you the same result, not the case when you substract, A1-B1 is 50 while B1-A1
is -50, excel would have no way to determine which number to substract from
which number, so the only way I see is to type the formula by hand =A1-B1 or
=B1-A1 depending on the result you want.

PS..I"m not an expert so this is just my opinion!

HTH
Jean-Guy

 

[Ragdyer]

In order to use Autosum for what you want, you'll have to key minus values
into the cells!

For example:
A1 = 100
A2 = -50
A3 = 25
A4 = -10

 

[Emanuel Vella]

Where should I write them?

In order to use Autosum for what you want, you'll have to key minus values
into the cells!

For example:
A1 = 100
A2 = -50
A3 = 25
A4 = -10

 

[Ragdyer]

In the appropriate cell(s)!