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
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 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
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies