Assuming the numbers have been typed into cells A1,b1,c1,d1 and f1
=A1+B1+C1+D1-F1
or
=SUM(A1:D1)-F1
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"teacher206" wrote in message
...
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