how do i do a subtraction formula

[Guest]

I am trying to put together a worksheet for work that involves adding and
subtracting columns. I cannot figure out the formula to subtract some of the
columns. Can anyone help

 

[Jerry W. Lewis]

=A1+B1-C1-D1

does what it looks like it should

=SUM(A:A,B:B)-SUM(C:C,D)

adds all of the cells in columns A and B and subtracts all of the cells
in columns C and D.

If neither of these are what you wanted, try asking a more specific
question.

Jerry

 

[Ragdyer]

There is no actual function for subtraction like the SUM() function is for
addition.
Simply use a minus sign [ - ].
Subtract Column A from Column B by entering this formula in Column C:

=B1-A1

You can then click in C1 again, and you'll see a small square in the lower
right corner of the cell.
This is called the "fill handle".
Hover the cursor over this square until the cursor changes from a fat white
cross to a skinny black cross.
Then click, and drag this down the column as far as needed to copy the
formula to every cell down Column C.

If you're going to add and subtract in the same formula:

=B1-(A1+A2+A3+A4)
OR
=B1-SUM(A1:A4)

In XL, there is almost always more then one way to perform calculation.

 

[Gord Dibben]

Jules

Common formula is =A1-B1 to subtract a cell's value from another cell's
value.

OR =SUM(A1:A9)-SUM(B1:B9) to subtract a range of cells.

Give us a sample(not a file) of your data layout and what you would like to do
with it.


Gord Dibben Excel MVP