View Single Post
  #2   Report Post  
Jerry W. Lewis
 
Posts: n/a
Default

=A1+B1-C1-D1

does what it looks like it should

=SUM(A:A,B:B)-SUM(C:C,D: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

jules wrote:

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