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

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.
 
L

Luke M

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Lookup Formula 4
What formula do I use? 2
Selecting and applying the correct forumla 2
Two cells look identical but give false response to "Exact". 5
Trying to match 1 value to multiple columns 10
if function (if more that 7 nesting) 2
How to make different cells fill in automatically from one entry? 3

Top