Translating a row formula down

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3150626%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3ETranslating%20a%20row%20formula%20down%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3150626%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3EHi%2C%20I%E2%80%99m%20trying%20to%20apply%20a%20formula%20down%20a%20column.%20However%2C%20I%20also%20need%20to%20increase%20the%20cell%20number%20by%201%20each%20time%20I%20move%20down.%20How%20do%20I%20do%20this%3F%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3Eetc%20original%20formula%20is%20%3DB9%2BB10.%20I%20need%20the%20formula%20beneath%20it%20to%20be%20B10%2BB11%20etc%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3150626%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EExcel%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E
Occasional Visitor

Hi, I’m trying to apply a formula down a column. However, I also need to increase the cell number by 1 each time I move down. How do I do this?

 

etc original formula is =B9+B10. I need the formula beneath it to be B10+B11 etc

2 Replies

@TomCampbell 

If you drag the cell with formula down it'll be as you ask. Or you mean something else?

@TomCampbellJust a picture to help. The formula in C2 is B2+B3. If you grab the corner of the cell and pull it down the column, it will copy the formula but advance it by one number like you requested. So the formula in C3 is B3+B4, etc. 

 Screenshot 2022-02-10 135202.png