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
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies