Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
simple subtraction
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 :] |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
simple subtraction
Try this:
=SUMPRODUCT(C3:C10-C2:C9) Note how the range is staggered. Biff "nikpleep" <u34670@uwe wrote in message news:7303cadccfab5@uwe... 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 :] |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
simple subtraction
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 "nikpleep" <u34670@uwe wrote in message news:7303cadccfab5@uwe... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell subtraction | New Users to Excel | |||
Subtraction Question | Excel Discussion (Misc queries) | |||
subtraction with dates | Excel Worksheet Functions | |||
How do I show a percentage in Excel? Or do a simple subtraction? | New Users to Excel | |||
how do i do a subtraction formula | Excel Worksheet Functions |