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