![]() |
#1
|
|||
|
|||
![]()
Hi there,
I am trying to do a fairly complex (for me) average formula of the CSE variety. My IF statement seems to be reading my WEEKDAY function value incorrectly. I'm trying to average some values only if they are between 1 and 7, and average some values that are only 1 OR 7. Please see the attached worksheet. Column A Time/Date Stamp Column B kWh Value Column C Weekday Formula (Irrelevant to final formula in columns g/h) Column F Timestamp column for Graphical Purposes Column G Cells with wonk formula To me this should be working. Anybody have any ideas? Thanks Fraser |
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 |