Formula for seasons in a multi-year worksheet

[emiguerra]

I have a spreadsheet with specific date columns (year, month, day) and
temperatures.

I created the average temperature for the summer for a year (=AVERAGE
(Lga!F357:F449)

However, since I have many years (from 1948 to 2009) the next row I
would need would be =AVERAGE(Lga!F722:F814). I would have to add 365
to each cell value (F357 to F722, etc).

Is there a way to automate this?

Thanks in advance.

 

[Bernard Liengme]

This
=AVERAGE(INDIRECT("Lga!F"&357+365*(ROW(A1)-1)&":F"&449+365*(ROW(A1)-1)))
will give the same result as =AVERAGE(Lga!F357:F449)
If you drag this down one row you get
=AVERAGE(INDIRECT("Lga!F"&357+365*(ROW(A2)-1)&":F"&449+365*(ROW(A2)-1)))
which is the same as
=AVERAGE(Lga!F722:F814).
And so on

best wishes

 

[Emilio]

Thank you very much, it worked.

This
=AVERAGE(INDIRECT("Lga!F"&357+365*(ROW(A1)-1)&":F"&449+365*(ROW(A1)-1)))
will give the same result as  =AVERAGE(Lga!F357:F449)
If you drag this down one row you get
=AVERAGE(INDIRECT("Lga!F"&357+365*(ROW(A2)-1)&":F"&449+365*(ROW(A2)-1)))
which is the same as
=AVERAGE(Lga!F722:F814).
And so on

best wishes