I have a column with about 1000 rows and I want to find the average for every 16 rows and add it in the next column without empty cells between them. I found this formula, which works perfect if my data starts from the first row.

```
=AVERAGE(OFFSET(INDIRECT("A"&ROW(A1)*16-15),0,0,16,1))
```

I am trying to make it work for data that starts from the second row, since the first row has the headers. I tried a lot of things without success. Any help?

## Best Answer

Consider:

should be placed in

B1If copied down:

B1will show the average ofA2thruA17B2will show the average ofA18thruA33etc.

EDIT#2:To get

B2to represent the average ofA2thruA17,use: