Formula AutoFill

%3CLINGO-SUB%20id%3D%22lingo-sub-687301%22%20slang%3D%22en-US%22%3EFormula%20AutoFill%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-687301%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EI%20have%20four%20spread%20separate%20spread%20sheets%2C%20that%20I%20am%20trying%20to%20sum%20up%20into%20one%20every%20time%20one%20of%20the%20four%20is%20edited.%20I%20am%20using%20this%20formula.%3C%2FP%3E%3CP%3E%3DSUM('%5B2019%20Q1.xlsx%5DCross%20Sell'!%24L%245%2B'%5B2019%20Q2.xlsx%5DCross%20Sell'!%24L%245%2B'%5B2019%20Q3.xlsx%5DCross%20Sell'!%24L%245%2B'%5B2019%20Q4.xlsx%5DCross%20Sell'!%24L%245)%3C%2FP%3E%3CP%3EThe%20issue%20is%20normally%20you%20can%20put%20the%20green%20box%20around%20two%20cells%20and%20drag%20it%20down%20or%20across%20and%20it%20will%20fill%20in%20the%20correct%20number%20or%20letter%20that%20need%20to%20be%20changed%2C%20but%20it%20isn't%20doing%20that%20so%20I%20have%20to%20fix%20every%20single%20formula.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20help!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-687301%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-688335%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20AutoFill%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-688335%22%20slang%3D%22en-US%22%3EIf%20you%20intend%20to%20copy%20your%20formula%20down%20rows%2C%20use%20relative%20row%20like%20this%3A%20%24L5%3B%20across%20columns%2C%20use%20relative%20column%20like%20this%3A%20L%245%3B%20or%20down%20rows%20and%20across%20columns%2C%20use%20relative%20reference%20like%20this%3A%20L5.%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hello,

I have four spread separate spread sheets, that I am trying to sum up into one every time one of the four is edited. I am using this formula.

=SUM('[2019 Q1.xlsx]Cross Sell'!$L$5+'[2019 Q2.xlsx]Cross Sell'!$L$5+'[2019 Q3.xlsx]Cross Sell'!$L$5+'[2019 Q4.xlsx]Cross Sell'!$L$5)

The issue is normally you can put the green box around two cells and drag it down or across and it will fill in the correct number or letter that need to be changed, but it isn't doing that so I have to fix every single formula.

 

Please help!

1 Reply
Highlighted
If you intend to copy your formula down rows, use relative row like this: $L5; across columns, use relative column like this: L$5; or down rows and across columns, use relative reference like this: L5.