Determining Additional Income Needed To Make Up Sales Gap

[JDixon10]

Currently I am trying to figure out how to easily calculate the additional revenue per month needed to meet a sales goal. For example over a 12 month period I need to achieve a sales goal of $84,996. That would mean I would need an average of $7,083 per month to achieve this goal. Of course we all know actual figures fluctuate month per month. I need to basically have something that will determine what extra revenue is needed for the remaining months to make up the difference in revenue loss from previous months to achieve the set goal. Any ideas?

[oeldere]

You get better help on your question if you add a small excel file, without confidential information.

Please also add manualy the expected result in your file.

[JDixon10]

example.xlsx

Here's sort of what I'm working with.

[oeldere]

c4=SUM($B$4:$B4) and drag down

d4=$A$2-C4 and drag down

see the attached file.