Ignore Hidden Cells Dunring Inconsistent Formula Calculation

[AllanJR]

Hello All,

I have a worksheet with a column of incrementing data.

The first problem I have is that when I hide rows I want the formula to ignore the hidden cells and continue the sequence.

The second problem is that my formula at the moment is inconsistent,
For example:

-- image removed --

And so on...........
So if you consider A1 to be the reference cell all further cells increment in blocks of 3 cells.

If I were to hide rows how can I get the formula to continue without taking hidden cells into consideration??

 

[AllanJR]

[TABLE="width: 100"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]100
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]=A1+2
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]=A2+2
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]=A3+6
[/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]=A4+2
[/TD]
[/TR]
[TR]
[TD]6
[/TD]
[TD]=A5+2
[/TD]
[/TR]
[TR]
[TD]7
[/TD]
[TD]=A6+4
[/TD]
[/TR]
[TR]
[TD]8
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Sorry my image did not upload to the original post