Replied 8 September 2017, 2:14 pm EST

Hello,

I would like you to know that in Spread, the cell references passed to the formulas are of two types, absolute reference and relative reference. When absolute cell references are passed, the formula remains same and accesses the same cells every time, to calculate a result. However, the relative cell reference passed to a formula, makes the formula to refer a different cell range relative to the location where the formula is placed. The cell references passed with a $ symbol means that we are passing absolute cell references, where as the one passed without this symbol refers to relative cell references. For example, if cell C2 has the following formula =SUM(A1:B1), then it means it is given a relative reference, and it would always refer to two cells in the row above it, like A1 and B1 in this case, now if this formula is pasted to cell E2, then it would change to =SUM(C1:D1), referring to two cells in the above row i.e C1 and D1.

Now if you don't want this formula to vary with the cell location then you would need to pass absolute cell references to this formula using the following syntax:

=SUM($A$1:$B$1)

So, whenever you would paste the formula, it would remain the same and would always refer to cells A1 and B1. You can also refer to this link for further clarification.

http://www.clubfarpoint.com/FarPointSupportSite/Modules/Docs/FormulaReference/formulas-relabsolute.html

Hope it will help you. Please let me know if you have any queries further.

Thanks,

Manpreet Kaur.