how do I substract

K

kiserlouisa

I am new to this. I am trying to do balance sheets. I need to add the rows
(which I have been able to do) then substract the 2 columns. I cannot
remember how to make the cells substract.
Thanks
 
G

Gord Dibben

To subtract one cell from another you would enter a formula in a third cell.

=A1-B1

You can also subtract ranges as in

=SUM(A1:A10)-SUM(B1:B10)


Gord Dibben Excel MVP
 

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

Regarding Compare and SUm the Range of Cells 2
need held for auto date calculation for adding years and substract 1
How do I retreive the last # in a column? 2
Substraction formula 4
Substracting from a column 5
Adding or Substracting to a current value 1
Adding or Substracting from a current value in table 2
Need formula in Excel to substract cell D from Cell C 2

Top