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

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

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

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
wrote:

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

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

For example D30 is =sum(d2:d28) f30 is =sum(e12/10) G30 is =sum(G2:G28)
now what I want is d35 = D30-G30 F35 =D35 + F30

Does this explain the problem better

"Sundew Chocobo" wrote:

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