What is the formula for subtracting the sum total of two cells

G

Guest

What is the formula for subtracting the sum total of two cells in nonadjacent
(nonconnecting) cells?
 
G

Gord Dibben

A1 = 120

D1 = 200

F1 has formula =D1-A1 returning 80

Other than that, don't know what you need.


Gord Dibben MS Excel MVP

On Tue, 28 Nov 2006 14:27:01 -0800, Sundew Chocobo <Sundew
 

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

Column sum incorrect upon subtracting 6
Shading When Selecting Nonadjacent Cells 1
Cause formulae totals to reflect negative and positive amount inpu 7
Subtracting Rounded Numbers 6
Subtracting Values from a Ranked List 4
Excel formula, sum the value cell and if empty cell left blank 0
subtract times with a negative result 1
Excel Sumproduct 0

Top