Opposite of Auto Sum

[lynn]

Is there a function, similar to AutoSum, that will instead
subtract numbers instead of adding them together ? Using
Excel 2000 or 2002

 

[Kevin Stecyk]

Lynn,

I am not sure ~exactly~ what you are hunting for.

If you want everything subtracted, then it is simply =-sum(range). Note the
negative sign in front of sum.

If you want the the all the numbers except the first number subtracted from
the first number, then...

= first_number - sum(all numbers except the first)

Does any of this help you?

Regards,
Kevin

 

[Jim]

=SUM(A2:A10)-A4

 

[Ken Wright]

Isn't that same as -SUM(A1:A10)

If not, then what do you mean by subtracting them all?

 

[lynn]

That's it. Thanks Kevin.

-----Original Message-----
Lynn,

I am not sure ~exactly~ what you are hunting for.

If you want everything subtracted, then it is simply =-sum (range). Note the
negative sign in front of sum.

If you want the the all the numbers except the first number subtracted from
the first number, then...

= first_number - sum(all numbers except the first)

Does any of this help you?

Regards,
Kevin








.