Go to Data > What-If Analysis > Goal Seek. In the Set Cell field, select the cell that contains your total sales (e.g., A5). In the To Value field, enter your target value, which in this case is ...

Microsoft Excel users, follow these two easy methods to reduce data entry time and errors when customized features aren't available.