Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 05-24-2010, 04:47 PM
FraserKitchell FraserKitchell is offline My weekday function aint working Windows XP My weekday function aint working Office 2007
Novice
My weekday function aint working
 
Join Date: Dec 2009
Posts: 21
FraserKitchell is on a distinguished road
Default My weekday function aint working

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
File Type: xls Forum.xls (37.5 KB, 20 views)
Reply With Quote
 

Tags
average if, cse, weekday



Similar Threads
Thread Thread Starter Forum Replies Last Post
My weekday function aint working lastincolumn function rdcsfd Excel Programming 7 02-08-2012 07:50 AM
My weekday function aint working FIND function, where? Yumin Word 2 04-02-2010 07:16 PM
My weekday function aint working Is this possible using the Vlookup or any other function? Delson Excel 4 02-08-2010 01:27 PM
My weekday function aint working 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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:28 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft