I was wondering if its possible to extend a formula to lower cells, while keeping certain figures fixed? I'll give an example to try make it clearer
say my original formula was in cell A1 and the formula was "A2+A3+A4".
Now i'd like to extend this formula to cell B1, so i do that and the formula reads "B2+B3+B4"
Instead of this, i want the formula in cell B1 to be "B2+B3+A4"
and then for cell C1 to be "C2+C3+A4" ect.
tryed to make that as clear as i could, hope you can help,