Excel 2007 : Counting and "pushing" sales question

[i3k]

Hi everyone first post here hope I'm doing this correctly.
I work in sales and I'm trying to make this formula work.

http://i53.tinypic.com/2py419c.jpg

Say week one I only made 10 sales, which is 50% of it
What im trying to do is put the other 50% (the other 10)
and spread it evenly with the next 4 weeks and so fourth for the next 3 weeks

the only thing that I came up with is in G10
=(P10-(COUNTIF(D10,"<0")))/5

and i know its prob wayyyyyy off ahah

THANKS IN ADVANCE!

(ignore the budget and goal)

[Bulu]

i3k,

See if attached file works for you. It works like this:

Current month: enter actual
Next month: use this formula to calculate remain balance for remaining months
=($J4-SUM($D4:D4))/(MAX($D$3:$I$3)-E$3+1)
2 month later: equal previous month
3 month later: equal previous month
etc...

Hope this helps.
Bulu

[i3k]

i3k,

See if attached file works for you. It works like this:

Current month: enter actual
Next month: use this formula to calculate remain balance for remaining months
=($J4-SUM($D4:D4))/(MAX($D$3:$I$3)-E$3+1)
2 month later: equal previous month
3 month later: equal previous month
etc...

Hope this helps.
Bulu

hmm i tried it and Im very confused, here is what Im working with
HELP.xlsx

[i3k]

help please =)