Subtracting various cells from one constant cell

[JJgold]

Say I have the number 325 in A1. Each time I type a number in A2, B2, C2, D2, E2, A3, B3, etc... I would like the number (325) in A1 to be reduced.

Also, how do I create a pull down list?

Thank you for your time.

 

[bbott]

Enter this formula in A1:

=325-SUM(A2:B3)

Adjust the range as needed.

 

[Chris Macro]

You could turn A2:?? into a table and then just make the formula in cell A1 = 325 - SUM(Table1)

 

[JJgold]

Perhaps I am not clear in my question....Okay, I am making a schedule on a calendar I created. I have a total of 325 hours in which to complete a project. Each part of the project will take "x" amount of hours each day. The numbers of hours will vary each day. Therefore, for each day I will type in the number of hours. So for May 30, I will have 5 hours to work that day. On May 31 I have 2 hours to spend on the project. Each time I type in the number of hours on a given day, I would like it to subtract from the total number of 325 hours. I hope this helps clarify what I am attempting to accomplish.

Thank you all for your help. This is an excellent resource!

 

[Aladin Akyurek]

You need VBA for substraction...

 

[JJgold]

How do I do that?

 

[VoG]

Maybe like this: right click the sheet tab, select View Code and paste in

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Row > 1 Then
    Application.EnableEvents = False
    Range("A1").Value = Range("A1").Value - Target.Value
    Application.EnableEvents = True
End If
End Sub