Subtraction from a column.
 

I have a column of numbers for example;
$140.00
$36.00
$428.00
$117.00
$300.00
$140.00
$36.00
$150.00
$500.00
$200.00
$300.00
$150.00
$5.00
$5.00
$24.00
$2,531.00

What I want to do is subtract a paid amount say $200 from the total
($2,531.00 this is calculated using the "Sum function"). How would I do this.
(Everytime I try to do this the total is mathametically wrong.)

Subtraction from a column.
 

Hi computerkiller,

Assuming your values are in A1:A15:
=SUM(A1:A15)-200

Alternatively, insert a new row to hold the amount paid and sum the new range. For example:
$140.00
$36.00
$428.00
$117.00
$300.00
$140.00
$36.00
$150.00
$500.00
$200.00
$300.00
$150.00
$5.00
$5.00
$24.00
-$200.00
$2,331.00 =SUM(A1:A16)

or
$140.00
$36.00
$428.00
$117.00
$300.00
$140.00
$36.00
$150.00
$500.00
$200.00
$300.00
$150.00
$5.00
$5.00
$24.00
$2,531.00 =SUM(A1:A15)
-$200.00
$2,331.00 =SUM(A16:A17)

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

"computerkiller" wrote in message
...
I have a column of numbers for example;
$140.00
$36.00
$428.00
$117.00
$300.00
$140.00
$36.00
$150.00
$500.00
$200.00
$300.00
$150.00
$5.00
$5.00
$24.00
$2,531.00

What I want to do is subtract a paid amount say $200 from the total
($2,531.00 this is calculated using the "Sum function"). How would I do this.
(Everytime I try to do this the total is mathametically wrong.)