Forum Discussion
Formula AutoFill
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.x...
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.