|
|
#1
11-11-2016, 08:02 AM
|
|||
|
|||
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! 
|
| Thread Tools | |
| Display Modes | |
|
|
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 |
Mac OS X 
Office for Mac 2011
Threaded Mode