View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Dana DeLouis[_3_] Dana DeLouis[_3_] is offline
external usenet poster
 
Posts: 690
Default HELP!!! I need to make a simple formula!

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

=SUM(A1:D1, -F1)

Add the first 4 columns together...


If it's really columns...

=SUM(A:D, -F1)

= = =
HTH
Dana DeLouis


On 1/8/2010 12:49 PM, 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