I am using Excel 2003 and am trying to average every two rows of data in one column,
starting from A1 and ending in A4, for example,

```
1 
2 
1 
2 

```

I try to do this average on the B1 column/row as follows (based on [this info](https://www.atlaspm.com/toms-tutorials-for-excel/toms-tutorials-for-excel-summing-every-nth-cell/))

```
=AVERAGE(IF(MOD(ROW(A1:A4),2)=0,A1:A4))

```

However, when doing the above, B1 returns a 0, even though I intended to get a 1.
What would be the best way to make this kind of averaging work?