# Calculate monthly average for (reaching) target

1. ## Calculate monthly average for (reaching) target

Hello everybody,

I'm new here and would like to ask for some help.

I have a main target which should be reached, let's say in my case 12,000,000.

I have 12 months time to reach this target,
but I have a deviation towards this target every month.
To reach this goal I should reach 1,000,000 every month.

So let's say for January I just reach 898,500, for February 923,540 and for March 1,000,154.

Let's assume it is beginning of April now, I would like to calculate how much do I have to achieve for the following 9 month so I will reach my target of 12,000,000 at the end of the year?
What is the average I have to reach every month to accomplish it.

Hope everybody understood my question.

Thanks very much  Register To Reply

2. ## Re: Calculate monthly average for (reaching) target

Say you're working on row 1. So...

A1 = 898,500
B1 = 923,540
C1 = 1,000,154

Formula:  `Please Login or Register  to view this content.`

And copy to the right  Register To Reply

3. ## Re: Calculate monthly average for (reaching) target

Thank you very much.
I used another formula, also with if, but you gave me the direction where to walk.
Was all a little bit more complex.
Should have given a screenshot.  Register To Reply

There are currently 1 users browsing this thread. (0 members and 1 guests) 