![]() |
#7
|
|||
|
|||
![]()
Thats wpuldnt get me the correct answer though, as I need to average on the timestamp, and make sure it is a weekday. So I at least need an AVERAGEIFS() with two conditions. Thus I need to look at the value at noon on every weekday for a whole month (larger data set not shown) and return THAT value.
|
Tags |
average if, cse, weekday |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
rdcsfd | Excel Programming | 7 | 02-08-2012 07:50 AM |
![]() |
Yumin | Word | 2 | 04-02-2010 07:16 PM |
![]() |
Delson | Excel | 4 | 02-08-2010 01:27 PM |
![]() |
Primeraman | Excel | 1 | 06-13-2006 10:16 AM |
Help with Combination function | sanasath | Excel | 0 | 12-13-2005 07:24 AM |