Creating Formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Adding several cells and then subtracting several cell from that total, and
showing the result in another cell?
 
=SUM(K1:K3)-SUM(K7:K9)

Put the above formula in "another cell".

Add's cells K1:K3 and then subtracts from that total the sum of cells K7:K9.
 
Lucille

Assuming cells with numbers are A1:A10

in B1 enter =SUM(A1:A10)-SUM(A2,A5,A6,A9)


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

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

I need to add multiple cells then subtract them from one cell c4+c6+c7+c9+c10+c11 and subtract them 1
Excel Formula or equation 3
multipule calculations in a single column 2
formula in excel 2
Update formula automatically for inventory 1
Excel Worksheet 1
Workday Formula to include date 0
How do I formulate total before Gst? 2

Back
Top