=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
|