Let's say I have numbers in range A1:A3
And I have a formula in B1: =A1
And I have a formula in C1: =sum(A1:A3)
How do I make the cell references in B1 and C1 "permanent", AND non-volatile? For example, if I move and drag cell A1 (or the range A1:A3), then the references in the formulas B1 or C1 will change (which could be bad if the formulas in column B and C are copied down, and there are other formulas dependent on the formulas in column B or C).
I can prevent this by using (for example) "Indirect" or "Offset", but those are volatile, and I am searching for simple non-volatile alternatives to those (if such a thing exists).
Thanks in advance!
And I have a formula in B1: =A1
And I have a formula in C1: =sum(A1:A3)
How do I make the cell references in B1 and C1 "permanent", AND non-volatile? For example, if I move and drag cell A1 (or the range A1:A3), then the references in the formulas B1 or C1 will change (which could be bad if the formulas in column B and C are copied down, and there are other formulas dependent on the formulas in column B or C).
I can prevent this by using (for example) "Indirect" or "Offset", but those are volatile, and I am searching for simple non-volatile alternatives to those (if such a thing exists).
Thanks in advance!