Forum Discussion
Calculate Monthly Sales Target Excel
Hi
I want to calculate individual monthly sales targets per advisor in my team based on an overall monthly target for the team.
So I have a monthly target of £28,487 with 11 people in the team, the issue is some only work part time so their target needs to be less than those working full time. How is best to work this out on excel?
Below is the example of the sheet I have, I've removed staff names but the working hours are real hours for my team, the £28,487.00 needs to be split equally across the team with those working less per week to have a fair share. The daily target should say Monthly Target sorry.
5 Replies
Thank you so much, the following doesn't quite work however as it's increasing as it goes down the list - all those on 40 hours a week should have the same monthly sales target as should those with 20 hours and so on, it should be based on their working hours what share of the full monthly target they have?
The formula that I posted does what you want if you have Microsoft 365, Office 2024 or Office 2021.
In an older version, use
=B5/SUM(B$5:B$15)*D$2
Then fill down.
Sorry thanks for the help but it doesn't quite work, those on 40 hours should all have the same target value as well as those on 20 hours for instance - all added together should value the full monthly target
Thank you
Enter the following formula in C5:
=B5:B15/SUM(B5:B15)*D2
This will spill to C5:C15.
