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,...
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.
