simple subtraction

[nikpleep]

Hi All,

I need help subtracting values in rows from each other.

My data looks like this
Values Difference
242
242.2 .2
256 ...???
267.4
...

I have 289 values that I would like to subtract from each other. I know the
basic =C3-C2, but is there a formula that will do it all at once.

Thanks :]

 

[T. Valko]

Try this:

=SUMPRODUCT(C3:C10-C2:C9)

Note how the range is staggered.

Biff

 

[MartinW]

Hi nikleep,

Your =C3-C2 should work fine. Just put it in the first cell you need it,
which, from the example you gave would be D3, then hover your mouse
over the bottom right corner of D3, when the cursor changes to a little
cross
click and drag down to the end of your data, the cell references will
update as you drag.

If you need to drag it past the end of your data to allow for further input
in column C then use =IF(C3="","",C3-C2)

HTH
Martin