Let cell mimic another one (with a slight difference)

[ingvar]

if i got a cell with a function, e.g. this one: =sum(a1:a3)

isnt it possible to make the cell next to the one with the function, mimic the function execept just use the letter next to the one being used

to make it clearer:
CELL1: =sum(a1:a3)
CELL2: will mimic but with the next letter, therefore =sum(b1:b3)

lets say i change the CELL1
CELL1: =sum (c1:c6)
then the CELL2 will mimic: and the function in CELL2 will be =sum(d1:d6)

[oeldere]

@Ingvar

Considering the forumrules, you have to stick by your earlier question.

[scott.s.fower]

yes just copy and paste the cell it will auto update the formula because the cells are not locked with $ signs (or what ever the symbol used in iceland is) for example =sum($a$1:$a$3) if you copy the cell it will still look at a1:a3 because it is locked

[ingvar]

To make it clearer, i WANT to make the cell next to the one with the function mimic but with the letter next to the one being used.

The auto fill (drag) and copy pasting does exactly what i'm looking for, but i really want a function that does what auto fill does. Because after auto filling the custom endings (e.g. g and kcal) gets earased

@oeldere i apologize if I've violated any of the forum rules, I just thought my last question was more straight to the point and my last thread was more missleading in what im looking for. I really appreciate your help though I will read the forum rules now.

[oeldere]

@ingvar

I appreciate you gonna read the forumrules.

I think it will be easier to make an header with the text g and kcal.

Then you can use the cells for calculations and you're able to drag the formula.