I am only laying out the first sheet at this stage with Labels & Formulas – no values yet. Each sheet has Month columns & Day rows. When I have the layout finished on the first sheet, I will copy the first sheet to make all the other sheets.

Each sheet so far has the following Rows under the day 31 Row:- "Total rainfall for each month", "No. of days rain fell each month", "Sum each month together to have rainfall so far & total rainfall for each year". I have managed to work out the formulas to do these.

What I would like now, for the bottom row, is the formula to work out "Average rain for each month" (over the 16 years, so far) & "Average rainfall per year" (over the 16 years, so far)

E.g. Add 1997 January to 1998 January sheet, then get average for those 2 Januaries in bottom row of 1998 sheet & so on until I have the average for the 16 Januaries. Then, in the bottom right, cell, the same for yearly averages.

Can any kind person, please compose this formula for me.

Nicko38 - Australia