I have a daily weather data set that rannges from 1900 to 2010 with date in column A, rain (total mm for day) column B, and transpiration column c. I would like to find average transpiration for 25/11 to 5/12 (ten days), for each year and then graph accordingly.

Is this possible, its doing my head in

Cheers
ATC123