HELP!!! I need to make a simple formula!

[teacher206]

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

 

[Gord Dibben]

=SUM(A11)-F1 entered in G1


Gord Dibben MS Excel MVP

 

[Bernard Liengme]

Assuming the numbers have been typed into cells A1,b1,c1,d1 and f1
=A1+B1+C1+D1-F1
or
=SUM(A11)-F1
best wishes

 

[trip_to_tokyo]

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(A11)

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.

 

[Jim Thomlinson]

So your formula is

A+B+C+D-F

What exactly is the issue? (other than you had multiple = signs in your
posted formula that were not necessary)

 

[Dana DeLouis]

All I want to do is use a formula to do this:

=SUM(A11, -F1)

Add the first 4 columns together...

If it's really columns...

=SUM(A, -F1)

= = =
HTH
Dana DeLouis

 

[Roger Govier]

see responses to your posting in other newsgroups

--
Regards
Roger Govier

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

__________ Information from ESET Smart Security, version of virus
signature database 4756 (20100109) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4756 (20100109) __________

The message was checked by ESET Smart Security.

http://www.eset.com