Formula To calculate sales projection for the coming months

[Climaxgp]

Hi Guys

I was just wondering if there is any formula to calculate sales projections for a coming month based on performance for the last couple of months?

I have attached a spreadsheet of the info..

[DonkeyOte]

I'm afraid this stuff is not my strong point by any means but do you mean something like:

B14: =FORECAST(G6,B3:F3,B6:F6)

Or are you looking to get a lot more sophisticated than that ?

[Climaxgp]

Hey DonkeyOte

Thanks for the reply!

Your replies are always welcomed!!

I was using the formula you provided, I would love to go more in depth in this and i'm sure there is more to this but i just don't know how to.. Once again, thanks for your response!! I really appreciate it!

[DonkeyOte]

Someone will come up with something more sophisticated I'm sure (or at least explain if not possible) - I'm afraid I know little... shg may be around later.

[Climaxgp]

Thanks buddy!

Appreciate it!

[shg]

Maybe as attached.