=SUM(A1:D1)-F1 entered in G1


Gord Dibben MS Excel MVP


On Fri, 8 Jan 2010 09:49:02 -0800, teacher206
wrote:

I am going crazy trying to figure this out myself! All I want to do is use a
formula to do this: Add the first 4 columns together to get a total. Then
subtract fromt he total to get a final balance. I will just be using simple
numbers no decimals or anything complicated.

A+B+C+D=SUM -F=Balance