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

Attached Files

Forum.xls (37.5 KB, 20 views)