Need help with Formulas for future projections by each recruiter

[palwirox]

Hello,

I have some sample spreadsheet made in which i have planned my next year yearly sales. I have also made Weekly GPM for each recruiter for them to keep track. I just need your help create the forumla in recruiter goals tab. In there i have created that number that each recruiter should be on weekly basis. If i change my yearly sales goals to different number than all the formulas should change in recruiters tab. Please advise.


HOW can i Attach the spreadsheet file?? so that you can see my spreadsheet. I can email it to somebody whoever wants to help me.

 

[DRSteele]

You can attach sample data (together with expected result) by following the instructions in the link below in my signature.