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

Lookup Formula 4
Compare two different workbook sheet to show the difference in text 0
A For Each in Range... with a .Find(what:="TJ", ... in it problem 15
Copy Cell in other sheet 1
Selecting and applying the correct forumla 2
use month in cell date to sum all relevant cells 2
Problem with SET & REF function 0
Subtract times? 2

Top