Hi,

Adding names at this stage seems unwise, though there is a way:
1st recommendation:
Just put =sum(a2:f2) in the 7th column and copy it across, if you want to include a "note to self" in the formula you could do this:
=sum(a2:f2)+N("sums 6 cells to left in same row")
which would give the same result, but you can write anything you like inside N("...")

2nd option (not recommended)
Select G1
Insert->Name->Define
put a name in the top, like 'six_to_left' (NB can't include spaces)
in the formula box put:
=a1:f1
(no $s)

Now every =sum(six_to_left) will sum the six cells to the left of the cell in which the formula is.

HTH