[andygrif]

The structure of the cell you want the total in should be as follows (say you want to subtract cell A2 from cell A1 in cell A3), you should type this in cell A3:


=sum(A1-A2)

If you wanted to add, then it's slightly different:

=sum(A1:A2)

You can also add multiple cells...eg if you want to add all the amount in cells A1 to A10 then your formula would beas follows:

=sum(A1:A10)

You can also do other features such as divide (/) or multiply (*) and percentages (*xx%) where xx is the percentage you want.

Let me know if you need any more info.