Opposite of Auto Sum

  • Thread starter Thread starter lynn
  • Start date Start date
L

lynn

Is there a function, similar to AutoSum, that will instead
subtract numbers instead of adding them together ? Using
Excel 2000 or 2002
 
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
 
Isn't that same as -SUM(A1:A10)

If not, then what do you mean by subtracting them all?
 
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








.
Click to expand...
 
Back
Top