[Solved] Absolute adress acts like relative address

[rltw]

In cell H8 I have: $H$9+$G$8

When I insert a row below row 8, H8 becomes $H$10+$G$8

I thought the whole idea of absolute addresses was to prevent this. What am I missing?

OO 2.3.1, W2K sp4

[Villeroy]

Nope, it's designed to keep track of data on insert/removal.
$H$9+$G$8 can be replaced with
=OFFSET($A$1;8;7)+OFFSET($A$1;7;6)
or
=INDEX($G$1:$H$65536;9;2)+INDEX($G$1:$H$65536;8;1)

[rltw]

Thanks, that worked like a charm. Although I notice that inserting a cell ahead of A1 (shift cells right) can throw it off, as if it sees the displaced cell as A1 even though it shows as A2.