|
|
#4
05-25-2010, 11:47 AM
|
|||
|
|||
sorry, I don't get it. I see you start to average the kilowatt hours for days that aren't Sunday. I don't understand the purpose of your modulus function... it looks like you're looking at the time and seeing if the formula results = the results produced by an identical formula in Col E.
You seem determined to use a array formula and that makes me wonder.. is this for school? 
|
| Tags |
| average if, cse, weekday |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 lastincolumn function
|
rdcsfd | Excel Programming | 7 | 02-08-2012 07:50 AM |
|
FIND function, where?
|
Yumin | Word | 2 | 04-02-2010 07:16 PM |
|
Is this possible using the Vlookup or any other function?
|
Delson | Excel | 4 | 02-08-2010 01:27 PM |
|
Need help on what function to use???
|
Primeraman | Excel | 1 | 06-13-2006 10:16 AM |
| Help with Combination function | sanasath | Excel | 0 | 12-13-2005 07:24 AM |
Windows 7 
Office 2010 (Version 14.0)
Threaded Mode