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?