In cell A 1 I have 1.

In cell B 1 I have 2.

In cell C 1 I have 3.

In cell D 1 I have 4.

In cell E 1 I have:-

=SUM(A1:D1)

This returns a total of 10.

In cell F 1 I have 6.

In cell G 1 I have:-

=(E1-F1)

This returns a total of 4.

The above seems to give you what you want.

If you agree please hit Yes.

Thanks.









"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