Sales Goals - using rolling 12 month sales and minimum monthly sales

I have a sales level that I need to track...My rolling 12 months' sales must be $85,000 and my currently monthly sales must be $7,000. I have a sheet that tracks the $85,000 and tells me what I need to achieve that, but I haven't figured out how to include the $7,000 monthly minimum....

The chart below is what I have. So for example, this month it's telling me I only need to sell another 3016.46 to hit the $85,000 rolling 12, but I actually need to hit $4821.79 to meet the $7k minimum.

Can someone help me with this?



Actual Rolling 12 Goal
Sep 2012 5,367.24 73,663.30
Oct 2012 5,649.93 69,496.28
Nov 2012 14,163.38 73,451.30
Dec 2012 4,129.33 71,957.17
Jan 2013 6,428.76 70,521.02
Feb 2013 6,714.74 71,965.46
Mar 2013 6,469.69 70,809.34
Apr 2013 4,889.80 67,033.80
May 2013 6,447.03 70,578.99
Jun 2013 5,504.92 71,851.00
Jul 2013 10,430.72 77,210.60 7,789.40
Aug 2013 3,533.00 79,728.54 5,271.46
Sep 2013 11,093.96 85,455.26 -455.26
Oct 2013 2,178.21 81,983.54 3,016.46

Thank you! So I guess I need another column to tell me what I have left to do in October? I like to enter my sales as I submit them so I know what I still need to do.

Yes, I do have a goal column...I would love for that to adjust as I enter data into the current month. So at the beginning of the month, it will show me what I need to do to reach the $85k and $7k, and as I enter sales for the month, have it adjust accordingly.

See attached. I made it with a Goal column and a "left to do this month" column...would love for these 2 to be combined, if possible. sample.xlsx

Thanks!

Thank you!!