nOOb formulas question

[Guest]

Ok can you walk me through this I am very new to this.
I have sheet 1. I have a starting balance on cell H1.
Also on that sheet I have a Total on cell D3.
Sheet 2 Column E will be my Recieved and Column G will be my paid.
I dont know what the sum column is for.
I need to have any number entries on Column E sheet 2 added to D3 sheet 1,
and subtract from H1 sheet 1.
Example: I have starting balance of $1000 in H1. And a Total on D3 of $500.
I add $20 to any cell in Column E. We will say E2. Now H1 equals $980, E2
equals $20, and D3 equals $520.

I barely know where to start so please be patient and make your explanations
detailed Thank you so much.

 

[JulieD]

Hi Patrick

what concerns me about your question is where the 1000 is coming from in H1
and the 500 in D3 ... however, assuming that you want to hard-code these
into the formula in the cell then the formulas to use in Sheet1!H1 is
=1000-SUM(Sheet2!E:E)

and the formula to use in Sheet1!D3 is
=500+SUM(Sheet2!E:E)

Cheers
JulieD