simple subtraction

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

nikpleep - 31 May 2007 21:30 GMT

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 :]

Reply to this Message

T. Valko - 31 May 2007 21:36 GMT

Try this:

=SUMPRODUCT(C3:C10-C2:C9)

Note how the range is staggered.

Biff

> Hi All,
>
[quoted text clipped - 13 lines]
>
> Thanks :]

Reply to this Message

MartinW - 01 Jun 2007 10:10 GMT

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

> Hi All,
>
[quoted text clipped - 13 lines]
>
> Thanks :]

Reply to this Message