I cant get my Sum(Offset formula to pull appropriate data.
I am starting a business and created a Breakeven to show my investors and partners what our numbers would look like depending on the number of sales reps we started out with.
Currently this is the formula I am using....
=+SUM(OFFSET(Sales!B$19,0,0,1+$F$4,1))
The goal: When cell F4 is showing 0 or empty the cell will display the value listed in Sales! B19. However if My investor wants to add 4 sales reps, they will change cell F4 to 4 and that will then multiply Sales! B19 by 4 and display that number.
Now whenever I change the number from 0 in cell f4 it just multiplys by 13....
I cannot get it not to and i dont know why.
Does this make sense?
I have attached the file so that someone can help if needed.
Goal: Get Sales Rep Payroll (Per Month) to Scale according to the number in cell F4
|