#1
|
|||
|
|||
dynamic ranges to calculate average
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! |
#2
|
||||
|
||||
Would a Pivot Table be acceptable?
__________________
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 |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
dynamic ranges to calculate average | teatree | Excel | 1 | 11-11-2016 10:03 AM |
Calculate average age | FTL | Excel | 1 | 08-09-2016 06:56 AM |
Dynamic chart ranges | GlowingApple | Excel | 1 | 02-17-2016 07:18 PM |
calculate average depending on drop-down values | virencm | Word | 0 | 08-06-2010 06:10 PM |
Dynamic Named Ranges using text | hannu | Excel | 0 | 06-22-2010 04:42 PM |