so… i have hourly readings recorded for a 1 year duration. i managed to get the mean monthly values (in a separate worksheet) for each month using a formula that selects the values of Jan, Feb, etc. Hence, the mean monthly is always set from Jan-Dec.