I have a time series measurement with a varying number of values per day. I would like to compute the average per day.
File should be attached, it is a smaller version of a sheet taken from this website:
http://harvardforest.fas.harvard.edu....html?id=hf006
You will see that I tried using if statements, but I don't know how to "close" the range with a second if-statement, since the amound of values differ. So I am guessing that there must be a better way to do it.
Please help,
Thanks!