What function do I use to subtract two cells in the same row?

  • Thread starter Thread starter mscott
  • Start date Start date
M

mscott

I set up a balance sheet and want to subtract expenses (col C) from income
(col B). I want the difference to display in col D on a particular line but I
can't find a function that will do this.
 
One cell in column C subtracted from one cell in column D:
=D2-C2
Everything in column C subtracted from everything in column D:
=SUM(D2:D100)-SUM(C2:C100)
 
Back
Top