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

Attached Files

Breakeven Lyte.xlsx (22.2 KB, 15 views)