Subtraction from a column.

C

computerkiller

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.)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top