Excel Problem

[jutty274]

Oh clever ones of the TEF. Could you please help me with a slight problem i am having with a formula in excel, i am trying to take away a series of numbers away from a total and leave a new total at the bottom of the column, i.e cell 1a is my starting total & i want to take away the total of cells 2a to 20a & leave 21a with the new total. But every time i try to do a formula it will not let me do it. I have the formulas at the top which they cover every possible maths problem known to man except how to subtract. I am using excel 2007 as it was free on my laptop when i got it. Does anyone know how to do this

[thedarkprince]

In cell 21a you should use =cell1a-sum(cell2a:cell20a)

This will only work if you have a static number of cells in the range though but you could in theory use the same formulae in a cell much lower and simply extend the range.

If you're dragging the formulae around remember to sticky the cells (F4).

[DA15red]

=1a-(sum of 2ato20a)

Sum of is the Greek symbol that looks like a capital E.  Drag from 2a to 20a.

That's the easy way.

The harder way is;

1a-(2a+3a+4a..... and so on)

[König]

use an Abacus

[jutty274]

Thanks everyone that has sorted it out. Dark Prince yours worked a treat once i took the word cell out of the cut & paste i done.