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,...
Enter the following formula in C5:
=B5:B15/SUM(B5:B15)*D2
This will spill to C5:C15.