sorry i mean B3, would return average of a3:a26.

Many thanks,
Reza

"Reza" wrote:

Hello Max,

My first value is on row 3, how can I adjsut the formula to still work, i.e.
B1 would return the average of a3:a26??

Thank you,



"Max" wrote:

Assume 24 hourly values start in A1 down
In B1: =AVERAGE(OFFSET($A$1,ROW()*24-24,,24))
Copy down to B365. B1 returns the average for A1:A24, B2 returns it for
A25:A48, etc
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Baffe" wrote:
I have a column with the measured temperature every hour of the year(8760
values). I would like to convert these to the mean value for each day (365
values).

Does anyone know a simple formula/function for this purpose?

/ Baffe