Is there an aggregate function like SUM which SUBTRACTS?

[lesotho72]

Hello,

We have a spreadsheet where, instead of adding (SUM) or multiplying (SUMPRODUCT) we want to subtract each item. Preferably we'd like to do this in a pivot table. i.e. Data is:

Item Value
X -10
X -30
X -20

So, we'd want the value to be -10 - (-30) - (-20) = 40. Default is always to add (+) every number -- so SUM = -60.

Any help greatly appreciated.

Thanks,
Dan

 

[mikerickson]

A formula like
=SUM(N(A1), -N(A2), -N(A3)) would work

 

[pgc01]

Hi

With the data in A1:A10, try:

=A1-SUM(A2:A10)

 

[Scott Huish]

This should work:
=SUM(A1,-(A2:A3))

Confirm with CTRL-SHIFT-ENTER rather than just Enter.

 

[lesotho72]

Thanks everyone! We'll give these a shot and let you know how it goes.

Thanks Again,
Dan