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!

Attached Files

hf006-03-autochamber.xlsx (131.3 KB, 18 views)

Would a Pivot Table be acceptable?

Attached Files

hf006-03-autochamber.xlsx (113.8 KB, 11 views)

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post