How do you skip a cell when dragging a formula down? For example, I use vlookup to match sales information to customers on a spreadsheet. These customers are grouped together and assigned a manager. I sum up each group to get a sales total per manager(subtotal). I do this month to month for the entire year, adding a column each month. Is there a way I can skip over the manager subtotal cells (in which i have the sum formula for each manager) when dragging down the vlookup formula? Thank you in advance for your reply?