I have a series of quarterly median rent prices over several decades and would like to create a separate list of annual average rents (see link). To get the 1990 average in the example I have used the following formula:
=AVERAGE(C4:F4)
When I try to drag the formula across though, the start and end cells only move one column over (i.e. D4:G4), rather than the four columns necessary to average the four median rents for 1991.
Is there a simple way to copy the formula over and have the column numbers move four across to average subsequent years?