# Calc: How to properly use OFFSET to the right with increasing Interval?

Assumed we have this table style **in sheet 1**:

```
A B C D E F G H
1 0.1 0.2 0.5 0.7 0.4 0.5 0.9 1.0
2
3
```

In **sheet 2** there have to be averages made out of the paired cells of sheet 1, means averages from A1:B1, C1:D1, E1:F1, and so on.

- AVERAGE(A1:B1) from sheet 1 should be in sheet 2: cell A1,
- AVERAGE(C1:D1) from sheet 1 should be in sheet 2: cell B1,
AVERAGE(E1:F1) from sheet 1 should be in sheet 2: cell C1, and so on...

`A B C D 1 0.15 0.6 0.45 0.95 2 3`

My assumption was to simply use the OFFSET-function with some command like that:

=OFFSET(AVERAGE(A1:B1),0,(COLUMN()-1)*2))

As the rows do not get switched, we can put a 0 into the row move option.

Unfortunately, this command does not work as expected. Any ideas?