I have a worksheet that calculates the new year budgets. The budgets are a
specific percentage. So far, the total budget number is coming out correct.
However, I need to disregard the sales for the misc rep. I'm not sure how to
do this without losing my sum (90,539) or possibly the %Inc (.175). Could
anyone shed some light on this?
Thanks,
Mel


Rep Item % Inc Sales Budget (D2+(d2*C2))
1 Item X 0.175 6,703 7874
2 Item X 0.175 7,078 8315
3 Item X 0.175 7,183 8438
4 Item X 0.175 590 693
5 Item X 0.175 17,936 21070
6 Item X 0.175 6,347 7455
7 Item X 0.175 5,455 6408
8 Item X 0.175 13,268 15586
Misc Item X 0.175 12,514 14700
77,074 90,539