How to Update Year to Date Amount Each Time I Input Data?

[nikimetzsb]

Here's what I'm trying to do:

We are calculating a column of numbers

Line 1 $249,000 Sales Price

Line 2 $7,470.00 Adjusted Commission Basis
Line 3 $373.50 Additional Fees
Line 4 $7,096.50 Adjusted Commission Basis (Line 1 minus line 2)
Line 5 $5,322.38 Gross Commission (75% of the Number above)

Then I want to take the amount that is calculated in line 4 and add that to the Year to Date total which is in another cell.

Line 6 YTD Income: $173,101.22
Line 7 YTD Volume: $7,515,500.00
Line 8 Com Basis: $238,584.24

HERE'S WHERE I NEED HELP:

I need Line 6 to increase by the amount calculated in line 5. Since it is a year to date total, it is going to change each time. What formula will make it do this automatically?

I need line 7 to increase by the calculated amount entered into Line 1.

I need line 8 to increase by the amount entered into line 2.

This is probably really easy, I just don't know what to call it to search how to do this.

I appreciate any help! Thanks!

[Loganeb]

Is this what you're looking for?

YearToDate.xlsx

[nikimetzsb]

Thank you for your reply! No, that's not really what I am looking for because that year to date figure will change each time we use the form. Right now that figure is 173,101, but next time we use the form it will be 178,423. In other words, it won't always be the same number, so I can't use the number as part of the formula.

It needs to be a place older. I need to tell Excel to increase whatever number is in this cell (line 6) by the number calculated in line 5.

I hope that makes sense.