Home

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
desipinkerman
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
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.
Related Conversations
Teams no longer auto launches
trandall in Microsoft Teams on
4 Replies
formula for data calculation
aayushman_mishra in Excel on
10 Replies
Creating A Sublist
zjohnson in Excel on
5 Replies
Excel Forumla to exclude empty cells.
ulken2019 in Excel on
6 Replies
Need FORMULA help please!!
marislav in Excel on
4 Replies